Importing data from Teamleader to pipedrive

Hi everyone !

I m working on a python script that will feed the Pipedrive account of my companies with the data from team leader.

i have an xslx that contain fields like first name, last name, email, companies name, last activity, date added, last edited, and a list of activities.
Activities field is a json text that contain date, short_description, long_description, type of the activity.
I have 2 file like that, one that contain companies with their activity, and contact (linked to companies) with their activities.

I need to import both file and link companies to contact and reversal.


[
{
“date”:1521560529,
“short_description”:“Flo Decq added contact: <a href=“https://app.teamleader.eu/contact_detail.php?id=21845378” >Aur\u00e9lie Bouchez.”,
“long_description”:"",
“type”:“contact”,
“custom_type”:-1
},
{
“date”:1521560529,
“short_description”:“Florence rcq added contact: <a href=“https://app.teamleader.eu/contact_detail.php?id=21845378” >Aur\u00e9lie B.”,
“long_description”:"",
“type”:“contact”,
“custom_type”:-1
}
]

This is how look like the note field (activities on Pipedrive).

When i import this, i got a lot of problem like i cant get an id for the contact so i can put on him some activities (to add the contact i go by the Pipedrive tool).

Do you have a solutions for me ? :slight_smile: that would be really nice.

Clerc James
james.clerc@epitech.eu