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

Hi, We have a subscription with mutliple rate plan and rate plan charge IDs. However, we want to turn on a subset of charges in the future, depending on a user action. I was wondering how we can achieve this using the TriggerCondition and TriggerEvent? Our subscription looks like this. Subscription  Rate Plan 1   Rate Plan Charge 1 - Triggered on Contract Effective Date  Rate Plan 2   Rate Plan Charge 2 - Triggered on a Specific date, date is TBD So when we activate the subscription for March 1,2020, we only want Charge 1 to be on the invoice. How can we achieve the same? We are using the subscribes API - https://www.zuora.com/developer/api-reference/#operation/Action_POSTsubscribe   Thanks, Vimal           ... View more

Hi, We just started using workflow for some of our custom notifications and i was wondering how i can give a global constant in the TO email address of the mail notification. We have a scenario where depending on the CASE value we need to email different addresses the details of the subscription. I have defined a global constant for the email addresses but i am wondering how i can add them in the To field of the email notification. Thanks, Vimal   ... View more

Hi, Today when we execute AqUA, the only option is to get back a file with the data. Can we look at returning JSON for the same response. We can look at creating page sizes to restrict the size. Thanks, Vimal ... View more