Hello,
I’m new to make and trying to build a scenario that watching gmail emails, retrieves the csv attachment and the POST the data to an endpoint in JSON Format.
Below is my scenario
When I run the scenario in runs 4 times (this is correct) and POST 4 times data to my endpoint, but the body is null.
If I run the module HTTP POST and give the sample values to my data the body is correctly posted.
Below the HTTP Settings
And a sample of my csv file.
TAXYDR2425438741367.csv (834 Bytes)
Any help?
Hello. Welcome to the Make Community!
From your scenario, it seems that you don’t need the text aggregator. You can directly try and pass the data from “Iterate Attachments” to the Parse CSV module.
Check if the output of the CSV/Parse CSV contains your document. Since you added a error handler route with a Resume, if your Parse CSV fails for any reason, the configuration of Resume will be used instead of the output of Parse CSV. If you didn’t fill any data in the Resume, the HTTP module will have empty fields. I suspect it’s the issue.
I suggest you remove the Resume, you remove the text aggregator, you map directly the Data from Iterate Attachments to the CSV field of Parse CSV. Be careful of the delimiter, apparently it’s a TAB.
Regards
Benjamin
I think I know what is wrong. You have commas “,” in your data. So when you map them in the target JSON, it breaks it.
Try to add a replace(15.col7;,;.)
To replace the commas in “Paid Amount” with a point.
Benjamin
