.png){kind=logo}
Handling Missing Inputs in API Data Push to CRM
I have an API that pushes data back to my CRM. It won't run if some inputs are missing. How do I get it to push the rest of the data, even if some inputs are missing?
To push data to your CRM even with missing inputs, you can use Clay's "write to table" feature and follow these steps: 1. Use the "Lookup record" action to check if the contact already exists in your CRM. 2. If the contact exists, use the "Update records" action. If not, use the "Create records" action. 3. When defining fields for your object, map only the fields that have data in your Clay table. 4. Enable the "Remove Blank Values" option to prevent overwriting existing data with blank values. This approach ensures that you're only pushing available data while preserving existing information in your CRM. If you need more specific guidance, please share your JSON or API configuration details.
Did that answer your question?
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Molly E.··If anyone else knows the answer to this, it would be appreciated. thanks :)
Jess B.··Molly E. there is a little blue toggle on the columns you have mapped in the http api column setup. If you click on that blue toggle, it will make that column value “optional” meaning a value doesn’t have to be present in order for the column to run! Go ahead wnd turn off that toggle for these columns in your http api setup and this should work!