Purchasing

Get Involved. Join the Conversation.

Topic

    Navan Mehra
    REST APIs for POsAnswered
    Topic posted October 7, 2019 by Navan MehraBronze Medal: 1,250+ Points 
    38 Views, 1 Comment
    Title:
    REST APIs for POs
    Summary:
    REST APIs for POs
    Content:

    Hi All,

    I have been using Purchase Order REST API for Procurement Cloud and observed few updates which I believe were part of recent patch updates. Earlier on calling the /purchaseOrders endpoint, it would return all the POs whereas oracle has introduced the concept of paging. This seems a useful update as the JSON response might have many POs and it could become troublesome to parse such large responses.

    I was able to update my program to loop through all POs, I was wondering if we can also filter what field do we need to see in the response. I see few querying capabilities have been added to REST request but didn't see options to filter fields. For example, I am only interested in OrderNumber and Creation Date for the POs returned as JSON response. Is there a way to query specific fields only ?

    Best Comment

    Suman Guha

    Please refer to this documentation:https://docs.oracle.com/en/cloud/saas/procurement/19c/fapra/op-purchaseorders-get.html

    In order to limit the fields in the response, you would need to use the "fields" query parameter as described in the documentation.

    Comment