Troubleshooting CRM Import Errors in Close.io

Derek Schultz · 2024-08-26 18:24:49.926135+00

I have a few contacts that I am trying to import back into our CRM ( ) but I am getting back errors. It isn't showing me whats wrong either so i have no clue how to fix it. Any help?

Troubleshooting CRM Import Errors in Close.io | Clay

11 comments

· Sorted by Oldest

Muhammad
·
·
What errors are you getting?
Bo (Clay)
·
·
Hey, thanks for reaching out! 😊 I’m sorry you’re experiencing this issue. Could you show us which table this is happening in? Please send us the link, that’ll help us take a closer look and assist you better. Let me know when you’re ready! 🚀
Derek Schultz
·
·
Its long but here it is

Derek Schultz

{"status":400,"response":{"req":{"method":"POST","url":"https://api.close.com/api/v1/lead/","data":{"url":"deshawresearch.com","name":"D. E. Shaw Research","contacts":[{"name":"Michael Fenn","title":"Systems Administrator / IT Manager","emails":[{"email":"michael.fenn@deshawresearch.com","type":"office"}],"phones":[{"phone":"+19803333927","type":"office"}],"custom.cf_Q99uPn2UHNFiMmCb9BIkZxT3EZhLZvCP16HhZXVE8f8":"Raleigh-Durham-Chapel Hill Area","custom.cf_RuqOXYmTZYP2oBgU2GH2NBJrDd9oCoyhc9SxPexdujS":"https://www.linkedin.com/in/michael-fenn-0110564a/","custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr.add":"Systems Administrator / IT Manager"}]},"headers":{"accept":"application/json","authorization":"Basic YXBpXzI5VDJKWFpmS0lXTzBkRDZ3U2w4eXYuMWdhdFdRcDEwUmJuNWs4VWhLWjBZTTo=","content-type":"application/json"}},"header":{"date":"Mon, 26 Aug 2024 15:47:29 GMT","vary":"Accept, Accept-Encoding","content-type":"application/json","x-frame-options":"SAMEORIGIN","x-rate-limit-limit":"240","x-rate-limit-remaining":"233","x-rate-limit-reset":"7.531522","ratelimit":"limit=240; remaining=233; reset=8","x-xss-protection":"1; mode=block","x-content-type-options":"nosniff","referrer-policy":"no-referrer-when-downgrade","trace-id":"8b44a340979703e965d5a0233071a098","set-cookie":["session=; Expires=Thu, 01 Jan 1970 00:00:00 GMT; Max-Age=0; Secure; Path=/; SameSite=Lax"],"x-envoy-upstream-service-time":"38","strict-transport-security":"max-age=31556926; includeSubDomains","ratelimit-limit":"60","ratelimit-remaining":"53","ratelimit-reset":"1","x-ratelimit-limit":"60, 60;w=1, 100;w=1","x-ratelimit-remaining":"53","x-ratelimit-reset":"1","content-encoding":"gzip","server":"envoy","connection":"close","transfer-encoding":"chunked"},"status":400,"text":"{"field-errors": {"contacts": {"errors": {"0": {"field-errors": {"custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr": "Some items are not valid."}, "errors": []}}}}, "errors": []}"}}

Muhammad
·
·
Go to settings <> custom fields <> and find out what format/data type this field is expecting.
custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr
The issue is you are trying to send a wrong data type to this field.
Derek Schultz
·
·
So this is a close issue?
Muhammad
·
·
No, it is issue in your json body
Derek Schultz
·
·
What is a json?
Muhammad
·
·
umm that body you are passing to close.io
Derek Schultz
·
·
Yup, I have no clue whats wrong. Can we hop on a call and talk about about the exporting process? This is a big piece for us before we buy.
Muhammad
·
·
Yes, i am available now. Derek Schultz

Muhammad
·
·
What errors are you getting?
Bo (Clay)
·
·
Hey, thanks for reaching out! 😊 I’m sorry you’re experiencing this issue. Could you show us which table this is happening in? Please send us the link, that’ll help us take a closer look and assist you better. Let me know when you’re ready! 🚀
Derek Schultz
·
·
Its long but here it is

Derek Schultz

{"status":400,"response":{"req":{"method":"POST","url":"https://api.close.com/api/v1/lead/","data":{"url":"deshawresearch.com","name":"D. E. Shaw Research","contacts":[{"name":"Michael Fenn","title":"Systems Administrator / IT Manager","emails":[{"email":"michael.fenn@deshawresearch.com","type":"office"}],"phones":[{"phone":"+19803333927","type":"office"}],"custom.cf_Q99uPn2UHNFiMmCb9BIkZxT3EZhLZvCP16HhZXVE8f8":"Raleigh-Durham-Chapel Hill Area","custom.cf_RuqOXYmTZYP2oBgU2GH2NBJrDd9oCoyhc9SxPexdujS":"https://www.linkedin.com/in/michael-fenn-0110564a/","custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr.add":"Systems Administrator / IT Manager"}]},"headers":{"accept":"application/json","authorization":"Basic YXBpXzI5VDJKWFpmS0lXTzBkRDZ3U2w4eXYuMWdhdFdRcDEwUmJuNWs4VWhLWjBZTTo=","content-type":"application/json"}},"header":{"date":"Mon, 26 Aug 2024 15:47:29 GMT","vary":"Accept, Accept-Encoding","content-type":"application/json","x-frame-options":"SAMEORIGIN","x-rate-limit-limit":"240","x-rate-limit-remaining":"233","x-rate-limit-reset":"7.531522","ratelimit":"limit=240; remaining=233; reset=8","x-xss-protection":"1; mode=block","x-content-type-options":"nosniff","referrer-policy":"no-referrer-when-downgrade","trace-id":"8b44a340979703e965d5a0233071a098","set-cookie":["session=; Expires=Thu, 01 Jan 1970 00:00:00 GMT; Max-Age=0; Secure; Path=/; SameSite=Lax"],"x-envoy-upstream-service-time":"38","strict-transport-security":"max-age=31556926; includeSubDomains","ratelimit-limit":"60","ratelimit-remaining":"53","ratelimit-reset":"1","x-ratelimit-limit":"60, 60;w=1, 100;w=1","x-ratelimit-remaining":"53","x-ratelimit-reset":"1","content-encoding":"gzip","server":"envoy","connection":"close","transfer-encoding":"chunked"},"status":400,"text":"{"field-errors": {"contacts": {"errors": {"0": {"field-errors": {"custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr": "Some items are not valid."}, "errors": []}}}}, "errors": []}"}}

Muhammad
·
·
Go to settings <> custom fields <> and find out what format/data type this field is expecting.
custom.cf_QLRFE7Dnt0BXIjzsWhjWD9Sdc8K0MzuQ8eHufTd30Sr
The issue is you are trying to send a wrong data type to this field.
Derek Schultz
·
·
So this is a close issue?
Muhammad
·
·
No, it is issue in your json body
Derek Schultz
·
·
What is a json?
Muhammad
·
·
umm that body you are passing to close.io
Derek Schultz
·
·
Yup, I have no clue whats wrong. Can we hop on a call and talk about about the exporting process? This is a big piece for us before we buy.
Muhammad
·
·
Yes, i am available now. Derek Schultz