Importing People to PipeDrive

  • 43Views
  • Last Post 28 September 2021
Jeff Richter posted this 27 September 2021

I am trying to load a .csv file to PipeDrive to create People using Skyvia and the email and phone number fields are not loading and the error is a JSON format error.  I have tried everything I can think of to fix the problem but still doesn't work.  Below is file as i could not seem to get it to load.


Name,Label,Last name,First name,Phone,Email,Organization,Visible to,ID,Position

REED WALHOF,,WALHOF,REED,(952) 808-9900,[email protected],,entire company,6778,ACCOUNT EXECUTIVE


Nataliia Nikulina posted this 28 September 2021

 Hello Jeff,


Thank you for contacting Skyvia Support team. 


The reason for the issue in your package is that the phone column of the Person's object in Pipedrive stores data in a JSON array format and should be mapped to a column in the same format. So you need to change a phone column in the CSV file you import to be in a JSON array format as well. 


Here is an example of how data in this column might look like:




Format of the fields is also described in the API documentation of a Pipedrive connector,

follow the link below for more information.





Please try to make the changes and let us know how it goes.



We look forward to hearing from you.


Best regards,


Customer Support Engineer