Nested Post Calls in SAP Build Apps

YashminBehera · 4 weeks ago

Hi all,

I’ve been working on an interesting use case where I’m creating a product catalog page that allows users to view individual product details pages when selecting a product. As part of this functionality, I’m leveraging a standard service to post data into two entities: A_SalesOrder and A_SalesOrderItem. Here's what I’ve encountered so far and where I need help!

What I’m Trying to Achieve

Create a Sales Order Record: Populate the header fields (e.g., Sales Order Type, Sales Order, Sales Organization, Distribution Channel, etc.) in the A_SalesOrder entity.
Add Line Items to the Sales Order: Populate the details (e.g., Item Category, Material, Quantity, Price, etc.) in the A_SalesOrderItem entity.
Link Header and Line Items: Ensure that the created SalesOrder is used to associate line items correctly.

sharing the payload I am following for the post request:

{
"d": {
    "SalesOrderType": "OR",
    "SalesOrganization": "1710",
    "DistributionChannel": "10",
    "OrganizationDivision": "00",
    "SoldToParty": "17100100",
    "to_Item": {
      "results": [
        {
          "SalesOrderItem": "000010",
          "SalesOrderItemCategory": "TAN",
          "SalesOrderItemText": "Trad.Good 11,PD,Reg.Trading",
          "Material": "TG11",
          "RequestedQuantity": "10",
          "RequestedQuantityUnit": "PC",
          "NetAmount": "175"

          }
      ]
}
  }
}

I am able to successfully post to the header fields using A_SalesOrder. However, when attempting to post data to the line items (A_SalesOrderItem), I encounter a 400 error (Bad Request) and the post fails.

this is while I am posting to the header fields.

while doing the post call to the line items I face this. ( The 941 refers to the salesOrder number while doing the post call to the A_SalesOrder service.)
1. - Tried associating the SalesOrder ID with the to_Item nested structure and posting to A_SalesOrderItem using an update record action.
  - Attempted to post to both entities (A_SalesOrder and A_SalesOrderItem) in a single nested post call.
Despite these efforts, I wasn’t able to achieve the desired result, and the 400 error persisted while posting to the line items.

- I’d appreciate guidance on how to make a nested post call that successfully links the A_SalesOrder header and A_SalesOrderItem line items. Specifically:
1. How to structure the request payload correctly for a nested post.
2. Whether there are specific settings or configurations required in the service or app variables for associating these entities.
3. Any example implementations or best practices for handling such scenarios in SAP Build Apps.
Looking forward to your insights and expertise to resolve this! 😊

@Dan_Wroblewski
@eshrinivasan
@Joni

SAP Build Apps

Joni · 4 weeks ago

Hi @YashminBehera It's not immediately clear from the screenshot what went wrong, except 400 error message, that indicate an issue with one or more parameters — potentially in the URL or the JSON payload of the request.

I’d recommend breaking the request into two parts:

First, try posting the sales order header first.
Once that succeeds, follow up with a separate request to post the sales order item(s).

You can refer to the example parameters (click on example value) for A_Sales_Order below from SAP API Hub:

POST > A_SalesOrder Header
POST > A_SalesOrder('{SalesOrder}')/to_item

You can also test the API call using cURL or Postman to isolate the issue outside of SAP Build Apps. Additionally, inspect the request directly from the SAP Build Apps preview by opening Chrome Developer Tools:

Go to the Network tab
Filter by Fetch/XHR
Review the actual request headers and payload being sent

This should give you better visibility into what's being passed and where the issue might be occurring.
Hope it helps.

YashminBehera · 4 weeks ago

Hi @Joni

Thank you for the reply,

I did try to post headers first and then separately post the sales order item(s), I was able to post the headers but while separately posting the sales order item(s) I receive " Request failed with status code 404".

I tried first with "create record" for sales order item(s) and then I tried the "update record" functionality for sales order item(s), I am unable to post in either of the ways.

Is there any way to post to both headers and the sales order item(s) which is nested in any certain way using sap build apps, can you please guide me in that way.

Regards,
Yashmin Behera

Joni · 4 weeks ago

hi @YashminBehera, did you try to troubleshoot with approach given? again I would encourage you to try with postman / curl first. You should be able to post sales order items with the example API link given previously.
Regards.