I’m building a Data Action that needs to fetch customer loyalty details from an external REST API and map the response to Architect variables for use in a flow. The external endpoint is /api/loyalty/status and it returns a JSON object with a nested array of transactions.
Here’s the response structure I’m dealing with:
{
"customerId": "12345",
"tier": "Gold",
"transactions": [
{
"id": "tx-001",
"amount": 50.00,
"date": "2023-10-01"
},
{
"id": "tx-002",
"amount": 120.50,
"date": "2023-10-05"
}
]
}
In the Data Action configuration, I’ve set up the input variables correctly and the HTTP GET request returns a 200 OK with the JSON payload. The issue is mapping the transactions array. I want to populate an Architect variable loyaltyTransactions with the entire array so I can iterate over it in the flow using a Loop block.
I’ve tried mapping the output variable loyaltyTransactions to the JSON path transactions in the Data Action response mapping section. When I test the Data Action in the UI, it says the mapping is successful. However, when I run the flow, the variable loyaltyTransactions comes back as null or an empty string, not the JSON array.
I also tried mapping it to the root $.transactions using JSONPath syntax, but that didn’t help either. The single value fields like tier and customerId map perfectly fine.
Has anyone successfully mapped a nested JSON array from a Data Action response to an Architect variable? Is there a specific format required for the variable type in the flow? I’ve checked the Data Action logs and the raw response is definitely there. Just can’t seem to get it into the flow variable correctly.