07-10-2025 07:33 AM
Hello,
I’m currently working with the Workato Flow App, and I’ve noticed that the incoming payload is not received in proper JSON format as expected.
Interestingly, when I use Python code within a regular recipe, the output is displayed correctly as a JSON object. However, when I try the same approach in a Flow App (Workflow), the output doesn’t appear in JSON format, it seems to be coming in as plain or formatted text, making it harder to work with.
I’ve attached a screenshot below for reference
07-30-2025 10:54 PM
Hi @yashasree ,
After submitting the form the response where it is store . If it is data table then trigger will be real-time at there u can enable formula mode using this formula to_json so it converts into json structure and if you use parse json then data pills will generate . I think it may helps you .
Can you confirm where the response are stored and is it file data type you are using
Thankyou
07-31-2025 01:53 AM
Hi @Obugari ,
After submission, the data is stored in a DataTable. Since the payload format varies being either JSON or XML, it couldn't be processed using formulas. To handle this complexity, we used Python code