I am trying to build a Data Action that calls our internal CRM endpoint to fetch customer order history. The call itself works fine and returns a 200 OK, but the mapping to Architect variables is failing. The response body is a nested JSON structure. Here is the snippet:
{
"orders": [
{
"id": "101",
"status": "shipped"
}
]
}
I want to map the first order ID to a variable named lastOrderId. In the Data Action mapping section, I tried using the JSON path $['orders'][0].id. The system says the mapping is invalid. I have also tried $orders[0].id and $.orders[0].id but nothing sticks. The documentation is vague about how the JSON parser handles arrays in this specific context. Is there a different syntax required for the response mapping? I need to extract this value to pass it to the next step in the flow. Any help would be appreciated.