topic Re: Payload Not Received in JSON Format in Workato Flow App in Workato Pros Discussion Board

Payload Not Received in JSON Format in Workato Flow App

yashasree — Thu, 10 Jul 2025 14:33:17 GMT

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

Re: Payload Not Received in JSON Format in Workato Flow App

rajeshjanapati — Fri, 11 Jul 2025 04:21:38 GMT

Hi @yashasree ,

May I know from where you are mapping data into Workflow apps page?

I mean from Recipe or from Data Tables, if you are mapping directly from Recipe check the mapping configuration, even we are updating the json... or if you mappping from Data Table check the data is correct or not in data table.

Re: Payload Not Received in JSON Format in Workato Flow App

yashasree — Fri, 11 Jul 2025 08:58:38 GMT

Hi @rajeshjanapati ,
We are retrieving data from the Datatable and mapping it from the recipe to the workflow

Re: Payload Not Received in JSON Format in Workato Flow App

rajeshjanapati — Fri, 11 Jul 2025 09:40:37 GMT

Okay @yashasree, what I understand is, you are mapping the Payload pill from the recipe to Workflow apps page directly ( as per my knowledge till now, in workato there is no option to display the data in the workflow apps page directly from the recipe, only from Datatable we can map the respective column data pill into Workflow apps page... also, correct me if I am wrong).

Then, if you are mapping the data pill directly to the workflow apps page from the recipe, have you checked the data format before mapping, whether it is in expected format or not?

Re: Payload Not Received in JSON Format in Workato Flow App

yashasree — Fri, 11 Jul 2025 10:09:22 GMT

Hi @rajeshjanapati ,
We can't map the data from the workflow, and I have verified the data format before to ensure it aligns with the expected structure

Re: Payload Not Received in JSON Format in Workato Flow App

Obugari — Thu, 31 Jul 2025 05:54:13 GMT

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

Re: Payload Not Received in JSON Format in Workato Flow App

yashasree — Thu, 31 Jul 2025 08:53:03 GMT

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