hi everybody ,
I am working on the integration of the pipedrive API via Talend ESB.
To do my mapping, the format of the extracted data is not in a correct json format.
Below is an example of the json format for organizations 
{
“success”:true,
“data”:[
{
“id”:1,
“company_id”:7596430,
“owner_id”:{
“id”:11633160,
“name”:“Aymen”,
“email":"pipedriveapip@gmail.com”,
“has_pic”:0,
“pic_hash”:null,
“active_flag”:true,
“value”:11633160
},
“name”:“Monstock”,
“open_deals_count”:2,
“related_open_deals_count”:0,
“closed_deals_count”:0,
“related_closed_deals_count”:0,
“email_messages_count”:0,
“people_count”:1,
“activities_count”:0,
“done_activities_count”:0,
“undone_activities_count”:0,
“files_count”:0,
“notes_count”:0,
“followers_count”:1,
“won_deals_count”:0,
“related_won_deals_count”:0,
“lost_deals_count”:0,
“related_lost_deals_count”:0,
“active_flag”:true,
“category_id”:null,
“picture_id”:null,
“country_code”:null,
“first_char”:“m”,
“update_time”:“2020-10-25 19:25:46”,
“add_time”:“2020-10-25 19:24:55”,
“visible_to”:“3”,
“next_activity_date”:null,
“next_activity_time”:null,
“next_activity_id”:null,
“last_activity_id”:null,
“last_activity_date”:null,
“label”:null,
“address”:null,
“address_subpremise”:null,
“address_street_number”:null,
“address_route”:null,
“address_sublocality”:null,
“address_locality”:null,
“address_admin_area_level_1”:null,
“address_admin_area_level_2”:null,
“address_country”:null,
“address_postal_code”:null,
“address_formatted_address”:null,
“owner_name”:“Aymen”,
“cc_email":"monstock6@pipedrivemail.com”
},
{
“id”:2,
“company_id”:7596430,
“owner_id”:{
“id”:11633160,
“name”:“Aymen”,
“email":"pipedriveapip@gmail.com”,
“has_pic”:0,
“pic_hash”:null,
“active_flag”:true,
“value”:11633160
},
“name”:“Org1”,
“open_deals_count”:0,
“related_open_deals_count”:0,
“closed_deals_count”:0,
“related_closed_deals_count”:0,
“email_messages_count”:0,
“people_count”:0,
“activities_count”:0,
“done_activities_count”:0,
“undone_activities_count”:0,
“files_count”:0,
“notes_count”:0,
“followers_count”:1,
“won_deals_count”:0,
“related_won_deals_count”:0,
“lost_deals_count”:0,
“related_lost_deals_count”:0,
“active_flag”:true,
“category_id”:null,
“picture_id”:null,
“country_code”:null,
“first_char”:“o”,
“update_time”:“2020-10-25 19:26:02”,
“add_time”:“2020-10-25 19:26:02”,
“visible_to”:“3”,
“next_activity_date”:null,
“next_activity_time”:null,
“next_activity_id”:null,
“last_activity_id”:null,
“last_activity_date”:null,
“label”:5,
“address”:null,
“address_subpremise”:null,
“address_street_number”:null,
“address_route”:null,
“address_sublocality”:null,
“address_locality”:null,
“address_admin_area_level_1”:null,
“address_admin_area_level_2”:null,
“address_country”:null,
“address_postal_code”:null,
“address_formatted_address”:null,
“owner_name”:“Aymen”,
“cc_email":"monstock6@pipedrivemail.com”
},
{
“id”:3,
“company_id”:7596430,
“owner_id”:{
“id”:11633160,
“name”:“Aymen”,
“email":"pipedriveapip@gmail.com”,
“has_pic”:0,
“pic_hash”:null,
“active_flag”:true,
“value”:11633160
},
“name”:“Organization1”,
“open_deals_count”:0,
“related_open_deals_count”:0,
“closed_deals_count”:0,
“related_closed_deals_count”:0,
“email_messages_count”:0,
“people_count”:0,
“activities_count”:1,
“done_activities_count”:0,
“undone_activities_count”:1,
“files_count”:0,
“notes_count”:0,
“followers_count”:1,
“won_deals_count”:0,
“related_won_deals_count”:0,
“lost_deals_count”:0,
“related_lost_deals_count”:0,
“active_flag”:true,
“category_id”:null,
“picture_id”:null,
“country_code”:null,
“first_char”:“o”,
“update_time”:“2020-10-27 10:06:47”,
“add_time”:“2020-10-27 10:06:47”,
“visible_to”:“3”,
“next_activity_date”:“2020-10-25”,
“next_activity_time”:null,
“next_activity_id”:1,
“last_activity_id”:null,
“last_activity_date”:null,
“label”:null,
“address”:null,
“address_subpremise”:null,
“address_street_number”:null,
“address_route”:null,
“address_sublocality”:null,
“address_locality”:null,
“address_admin_area_level_1”:null,
“address_admin_area_level_2”:null,
“address_country”:null,
“address_postal_code”:null,
“address_formatted_address”:null,
“owner_name”:“Aymen”,
“cc_email":"monstock6@pipedrivemail.com”
}
],
“additional_data”:{
“pagination”:{
“start”:0,
“limit”:100,
“more_items_in_collection”:false
}
},
“related_objects”:{
“user”:{
“11633160”:{
“id”:11633160,
“name”:“Aymen”,
“email":"pipedriveapip@gmail.com”,
“has_pic”:0,
“pic_hash”:null,
“active_flag”:true
}
}
}
}
thank you for your solutions in advance