Folks, I am working on a workflow, where i need to query the additional columns for a given set of subscriptions and return the result in a JSON response. Here's my input JSON attached in the body { "Subscription":[ { "Id":"2c92c0f9709f71c60170a7aba29f42af" }, { "Id":"2c92c0f8709f61890170a7ac2d7e7440" } ] I am trying to parse this JSON and get it stored in the workflow and use it in a Data Query. I am using Logic:JSONTransform for this, but i am not able to parse the input JSON. Here are the task details, { "workflow": { "id": 22607, "name": "", "description": "", "parameters": { }, "data": { }, "original_workflow_id": null, "type": "Workflow::Setup", "ondemand_trigger": true, "callout_trigger": true, "scheduled_trigger": false, "interval": null, "timezone": null, "status": null, "finished_at": null, "css": { "top": "40px", "left": "35px" }, "notifications": { }, "started_at": null, "call_type": "ASYNC", "priority": "Medium", "sync_trigger": false, "run_mode": "automated", "delete_ttl": 60, "task_summary": { } }, "tasks": [ { "id": 46674, "name": "Parse Input JSON", "parameters": { "template": "{\r\n \"SubscriptionId\":Subscription.Id\r\n}", "placement": "JSONTransform", "processor": "JSONata", "csv_headers": "\"SubscriptionId\"\r\n", "replace_payload": "true", "strict_variables": "true" }, "action_type": "Logic::JSONTransform", "object": null, "object_id": null, "call_type": "SOAP", "task_id": null, "original_task_id": null, "original_workflow_id": null, "status": null, "error": null, "error_details": null, "process_id": null, "css": { "top": "10px", "left": "360px" }, "concurrent_limit": 9999999, "iterate_row_reference": null, "error_class": null, "object_batched_reference": null, "tags": [ "" ], "priority": "Medium", "assignment": [ ] } ], "linkages": [ { "source_workflow_id": 22607, "source_task_id": null, "target_task_id": 46674, "linkage_type": "Finish" } ] } Any pointers on how to do this? Thanks, Vimal
... View more