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 ? 
that would be really nice.
Clerc James
james.clerc@epitech.eu