Importing People to PipeDrive

  • 27Views
  • Last Post 3 weeks ago
0
votes
Jeff Richter posted this 3 weeks ago

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,rwalhof@innovativeos.com,,entire company,6778,ACCOUNT EXECUTIVE

 

0
votes
Nataliia Nikulina posted this 3 weeks ago

 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:

 

[{"label":"work","value":"+321654987","primary":true},{"label":"work","value":"123456","primary":false}]

 

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

follow the link below for more information. 

 

https://developers.pipedrive.com/docs/api/v1/Persons#addPerson

  

 

 

 

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

 

 

We look forward to hearing from you.

 

Best regards,

Nataliia,

Customer Support Engineer

Close