Hi All - has anyone found a way to handle arbitrary object names in JSON responses? (see format 1 below)
I'm working with a custom app internally that breaks out transaction amounts by period for a given transaction. Each period is returned as a JSON object with periods as keys (format YYYYMM), which can be arbitrary depending on what periods the transaction contains.
Format 1: JSON object with arbitrary object names. As far as I know this won't work with Workato unless each unique period is defined in the JSON response schema:
{
"summary": {
"202011": {
"period": "202011",
"finance_total": 0,
"order_payments_total": 458,
"seller_fees_total": -45.8,
"seller_fee_discounts_total": 0,
"total": 412.2,
"count": 2
}
},
"meta": {
"status": 200
}
}
Format 2: changing format 1 to a format that I know is compatible with Workato (JSON array w/o named keys).
{
"meta": {
"status": 200
},
"category_by_period": [
{
"period": "202011",
"finance_total": 0,
"order_payments_total": 458,
"seller_fees_total": -45.8,
"seller_fee_discounts_total": 0,
"total": 412.2,
"count": 2
}
]
}
