Hey @Terry_Ruch , so most likely the system who send this data is not setting the “content-type” header properly. Either you would have to modify this header if you can, or you can use the “JSON” module and use the “Parse JSON”.
It looks like the output bundle isn’t actually valid JSON (checked when pasted into https://jsonformatter.org).
You can tell by the fact that the key (in red) contains the entire “payload” (data), and the double quotes are escaped. The value (in green) of that key contains an empty string, which is where your data/collection goes:
@samliew this stringified JSON output is what you get when you check the output within Make of a webhook module. This is a make thing…
if you look at the screenshot you can see the data looks OK and it ends at the last } so probably a typo
@Terry_Ruch Can you double check the JSON and then try the parser? See what happens?
OK, so after digging into this more it looks like the application type is `application/x-www-form-urlencoded. It’s a zapier integration inside of Carrot which is a website program for real estate investors.
I’m not even sure if I’m using Parse json correctly but it did go and grab and recognize all the different items in the generator. It just errors when I try to run it.
Like I said earlier, that is not JSON and you CANNOT use the “Parse JSON” module for this (at least not directly). The server is basically saying this is not JSON by sending the content type header as “application/x-www-form-urlencoded”. A JSON response would contain something like “application/json”. I said: This is actually a bug on the external service and should be reported to them.
What you can do, is try to set the “JSON pass-through” field to YES. This can only can be done when creating/setting up the webhook, so you can delete the existing one you’ve got.
Yes so the data you receice is not formatted correctly and has the wrong headers. Try this;
enable json passthrough on the webhook
You can do this underneath the menu item Webhooks → find the webhook → Edi
You don’t need to delete youe webhook at all
use a regex pattern and search for the parts you want to remove, so in this case you only want to end up with the JSON data so you can parse it later. How to use Regex in Make?
You can use the replace() function to replace parts with an emptrystring (remove the parts you don’t need).
use the JSON parser module and parse out the data you are left with
It does require a bit of effort, so ideally you want to fix the side of the input. If you can modify system which sends this data, that would be the best way
