I’m trying to use “Watch records” with Airtable to collect new records from a table. Then I want to POST these records to SOS Inventory (an ERP system) using a custom API call.
I’m able to collect records from Airtable, but I’m getting a 500 error when trying to POST to the ERP system:
Here is my SOS Inventory current setup:
1 of 2
2 of 2
Any advice on POSTing data that is coming from another source would be very helpful.
Hi @Brandon_Harding
First thing i suggest to add “ before and after the string param.
Also 500 status code is error on the server side
If they don’t handling good error messages then they just throw with general error
Thanks! I tried adding quotes but am still getting a 500 error.
I reached out to SOS Inventory for support.
In these types of cases you can use a Create JSON module to create the JSON to pass into future modules, especially custom API calls. JSON modules help validate your data and automatically handle encoding, etc…
JSON modules allow you to supply an example payload from which it can build a data structure. You can then just fill in the fields with your data.
Create JSON would go between Airtable and SOS Inventory modules.
Thanks Donald. I was considering this approach and coupling it with a regular HTTP request module.
