I am trying to access data by webhook from Pipedrive. The resolve properties should enable me to access my cusotmm fields and the values. Somehow it only resolves the empty custom fields and the fields which contain values appear only as API keys and labels
this is the data output from the get person node:
{
"company_id": 7841682,
"related_open_deals_count": 0,
"related_closed_deals_count": 0,
"participant_open_deals_count": 0,
"participant_closed_deals_count": 0,
"files_count": 0,
"notes_count": 0,
"followers_count": 1,
"related_won_deals_count": 0,
"related_lost_deals_count": 0,
"active_flag": true,
"first_char": "t",
"next_activity_time": null,
"next_activity_id": null,
"last_activity_id": null,
"3faad09cdf8c411da46585a605766c43625be71c": "154,153",
"5f31302c74a83900f8af769f75245d0ba00102a0": ",,",
"fa29202a69b7f9418be192d4f71d0fc3cfc5c630": "0",
"org_name": "Inhalt und Form Marketing Technology",
"cc_email": "[email protected]",
"owner_name": "iundf MT Support",
"ID": 30628,
"Eigentümer": {
"id": 12002136,
"name": "iundf MT Support",
"email": "[email protected]",
"has_pic": 1,
"pic_hash": "753c49b0101ac72af5ecc7d8be52231c",
"active_flag": true,
"value": 12002136
},
"Organisation": {
"name": "Inhalt und Form Marketing Technology",
"people_count": 7,
"owner_id": 12002136,
"address": null,
"active_flag": false,
"cc_email": "[email protected]",
"value": 66823
},
"Name": "test5 contact5",
"Vorname": "test5",
"Nachname": "contact5",
"Offene Deals": 0,
"Geschlossene Deals": 0,
"Anzahl E-Mail-Nachrichten": 0,
"Gesamte Aktivitäten": 0,
"Erledigte Aktivitäten": 0,
"Zu erledigende Aktivitäten": 0,
"Gewonnene Deals": 0,
"Verlorene Deals": 0,
"Telefon": [
{
"label": "work",
"value": "123456",
"primary": true
}
],
"E-Mail": [
{
"label": "",
"value": "[email protected]",
"primary": true
}
],
"Zuletzt aktualisiert am": "2022-01-04 08:23:50",
"Kontaktperson erstellt": "2021-08-11 14:23:45",
"Sichtbar für": "gesamtes Unternehmen",
"Profilbild": null,
"Nächstes Aktivitätsdatum": null,
"Letztes Aktivitätsdatum": null,
"Letzte E-Mail erhalten": null,
"Letzte gesendete E-Mail": null,
"Label": null,
"Funktion Kontakt": null,
"Opt-out Date": null,
"Erfassungsdatum": null,
"Mutationsdatum": null,
"Anrede": "Frau",
"Publikationen": null,
"Job Titel": "",
"Firmenabteilung (Kontakt)": "",
"Land": "",
"Kanton / Bundesland / Land": "",
"Briefanrede": null,
"Kontaktstatus / Beziehung": null,
"Austrittsdatum Mitgliedschaft": null,
"Eintrittsdatum Mitgliedschaft": null,
"Hauptkontakt Mitgliedschaft": null,
"Postfach Nr. (Kontakt)": null,
"Postfach PLZ (Kontakt)": null,
"Sprache": "Deutsch",
"Letztes Aktivitätsdatum (ZOHO)": null,
"Postfach (Kontakt)": null,
"Adresszusatz": null,
"Ort (Kontakt)": "",
"PLZ (Kontakt)": 0,
"Strasse (Kontakt)": "",
"Email opt-out": null,
"Seminar Teilnahmen": null,
"Geburtsdatum": null,
"Interessen": null,
"Privat Person": null,
"Quelle": null,
"Update Feld": "API",
"Primäre Organisation": "Inhalt und Form Marketing Technology",
"Marketinglabel Kontakte (Friendly)": null,
"Aktuelle Marketing Kampagne": "",
"Gast von Unternehmen": "",
"Stellung in der Unternehmung": null
}
Anyone knows how to properly encript the data so i can afterwards create a new contact in mautic?
Thank you for your help.
Information on your n8n setup
n8n Version:
0.144.0
Source Code:
License:
Apache 2.0 with Commons Clause