Problems transferring data to getresponse

Hello everyone, I retrieved leads from LinkedIn via oauth2 authentication and it returned to me in json format, looking like this:

However, when sending this data, such as name, email, payload to getresponse, it only returns the first data… how can I resolve this issue? (below there are two prints, the first is when recovering via authentication, the same as above, but with some fields open. And the second print shows what it looks like when trying to transfer to the getresponse fields)

Perfect, you are most likely helping the first question in another company account, but to reformulate the question and start again, we opened another one here, due to the fact that the functions mentioned in the previous question are not working for our objective, which would be this current question, So, to open a more appropriate question that you can understand, we opened another case on this account, thank you!

2 Likes

you are not sharing the json data , it will be best if you share so that it can be more accurate , it will be done by get map function only , all you have to do is use them in a right way

2 Likes

I understand, below the json:

For you to understand, I put it in a comment (//data I want to get below)–
to understand what I want to get in the middle of the json

[
{
“statusCode”: 200,
“headers”: [
{
“name”: “content-type”,
“value”: “application/json”
},
{
“name”: “date”,
“value”: “Thu, 05 Oct 2023 19:11:34 GMT”
},
{
“name”: “transfer-encoding”,
“value”: “chunked”
},
{
“name”: “connection”,
“value”: “keep-alive”
},
{
“name”: “x-li-fabric”,
“value”: “prod-lva1”
},
{
“name”: “report-to”,
“value”: "{"group":"network-errors","max_age":2592000,"endpoints":[{"url":"https://www.linkedin.com/li/rep\“}],\“include_subdomains\”:true}”
},
{
“name”: “nel”,
“value”: “{"report_to":"network-errors","max_age":1296000,"success_fraction":0.00066,"failure_fraction":1,"include_subdomains":true}”
},
{
“name”: “x-li-pop”,
“value”: “prod-lva1-x”
},
{
“name”: “x-li-proto”,
“value”: “http/1.1”
},
{
“name”: “x-li-uuid”,
“value”: “AAYG/ORvIJH8EzcD3ijq6Q==”
},
{
“name”: “set-cookie”,
“value”: “bcookie="v=2&6e276a64-a39e-4e9e-8f18-48ccc44fbb46"; domain=.linkedin.com; Path=/; Secure; Expires=Fri, 04-Oct-2024 19:11:34 GMT; SameSite=None”
},
{
“name”: “x-li-route-key”,
“value”: “"b=VB18:s=V:r=V:a=V:p=V:g=4642:u=1242:x=1:i=1696533094:t=1696571828:v=2:sig=AQGZP8hcWnxRcP4zi2a7J8amgDMwI8jc"”
}
],
“data”: {
“paging”: {
“start”: 0,
“count”: 10,
“links”: ,
“total”: 2
},
“elements”: [
{
“form”: {
“name”: “LeadGen form for SoftExpert - Software for Excellence”,
“hiddenFields”: [
{
“name”: “Entity name”,
“value”: “SoftExpert - Software for Excellence”
}
],
“id”: “7100178873316782080”,
“content”: {
“questions”: [
{
“questionId”: 558337,
“question”: {
“localized”: {
“en_US”: “First Name”
}
},
“responseEditable”: true,
“name”: “firstName”,
“questionDetails”: {
“textQuestionDetails”: {
“maxResponseLength”: 300
}
},
“predefinedField”: “FIRST_NAME”,
“responseRequired”: true
},
{
“questionId”: 563697,
“question”: {
“localized”: {
“en_US”: “Last Name”
}
},
“responseEditable”: true,
“name”: “lastName”,
“questionDetails”: {
“textQuestionDetails”: {
“maxResponseLength”: 300
}
},
“predefinedField”: “LAST_NAME”,
“responseRequired”: true
},
{
“questionId”: 558345,
“question”: {
“localized”: {
“en_US”: “Email Address”
}
},
“responseEditable”: true,
“name”: “email”,
“questionDetails”: {
“textQuestionDetails”: {
“maxResponseLength”: 300
}
},
“predefinedField”: “EMAIL”,
“responseRequired”: true
},
{
“questionId”: 560961,
“question”: {
“localized”: {
“en_US”: “Job title”
}
},
“responseEditable”: true,
“name”: “jobTitle”,
“questionDetails”: {
“textQuestionDetails”: {
“maxResponseLength”: 300
}
},
“predefinedField”: “JOB_TITLE”,
“responseRequired”: true
},
{
“questionId”: 556417,
“question”: {
“localized”: {
“en_US”: “Company name”
}
},
“responseEditable”: true,
“name”: “company”,
“questionDetails”: {
“textQuestionDetails”: {
“maxResponseLength”: 300
}
},
“predefinedField”: “COMPANY_NAME”,
“responseRequired”: true
}
],
“description”: {
“localized”: {
“en_US”: “Share your information below with SoftExpert - Software for Excellence to be contacted with more information”,
“pt_BR”: “Compartilhe suas informações abaixo com a organização SoftExpert - Software for Excellence para receber mais informações”
}
},
“legalInfo”: {
“consents”: [
{
“consent”: {
“localized”: {
“en_US”: “SoftExpert - Software for Excellence may contact me via email”,
“pt_BR”: “A organização SoftExpert - Software for Excellence pode entrar em contato comigo por e-mail”
}
},
“checkRequired”: false,
“id”: 000
}
],
“legalInfoId”: 232143124523525325,
“privacyPolicyUrl”: “Aviso de Privacidade - SoftExpert”,
“legalDisclaimer”: {
“localized”: {
“en_US”: “SoftExpert - Software for Excellence may use your name and email address to send you communications about the company’s products.”,
“pt_BR”: “A organização SoftExpert - Software for Excellence pode usar seu nome e e-mail para enviar comunicados a você sobre os produtos da empresa.”
}
}
},
“headline”: {
“localized”: {
“en_US”: “Contact SoftExpert - Software for Excellence”,
“pt_BR”: “Entrar em contato com a organização SoftExpert - Software for Excellence”
}
}
},
“creationLocale”: {
“country”: “BR”,
“language”: “pt”
}
},
“leadType”: “COMPANY”,
“leadMetadataInfo”: {},
“associatedEntityInfo”: {
“associatedCompany”: {
“organizationUrn”: “urn:li:organization:333333333333”
}
},
“versionedLeadGenFormUrn”: “urn:li:versionedLeadGenForm:(urn:li:leadGenForm:333333333333333333,1)”,
“ownerInfo”: {
“organizationInfo”: {
“organizationUrn”: “urn:li:organization:33333333333333”
}

                    //data I want to get below
                },
                "id": "teste",
                "submittedAt": 213123213,
                "testLead": true,
                "formResponse": {
                    "consentResponses": [
                        {
                            "accepted": false,
                            "consentId": 1
                        }
                    ],
                    "answers": [
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste@teste.com"
                                }
                            },
                            "questionId": 1231
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "Mateus"
                                }
                            },
                            "questionId": 3213
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "Linhares"
                                }
                            },
                            "questionId": 323232
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "marketing"
                                }
                            },
                            "questionId": 232323
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "Soft for Excellence"
                                }
                            },
                            "questionId": 33333
                        }
                    ]
                }
            },
            {
                "form": {
                    "name": "LeadGen form for SoftExpert - Software for Excellence",
                    "hiddenFields": [
                        {
                            "name": "Entity name",
                            "value": "SoftExpert - Software for Excellence"
                        }
                    ],
                    "id": "33333333333333",
                    "content": {
                        "questions": [
                            {
                                "questionId": 3333,
                                "question": {
                                    "localized": {
                                        "en_US": "First Name"
                                    }
                                },
                                "responseEditable": false,
                                "name": "firstName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 2222
                                    }
                                },
                                "predefinedField": "FIRST_NAME",
                                "responseRequired": true
                            },
                            {
                                "questionId": 22222,
                                "question": {
                                    "localized": {
                                        "en_US": "Last Name"
                                    }
                                },
                                "responseEditable": true,
                                "name": "lastName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 22
                                    }
                                },
                                "predefinedField": "LAST_NAME",
                                "responseRequired": 22
                            },
                            {
                                "questionId": 558345,
                                "question": {
                                    "localized": {
                                        "en_US": "Email Address"
                                    }
                                },
                                "responseEditable": true,
                                "name": "email",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "EMAIL",
                                "responseRequired": true
                            },
                            {
                                "questionId": 560961,
                                "question": {
                                    "localized": {
                                        "en_US": "Job title"
                                    }
                                },
                                "responseEditable": true,
                                "name": "jobTitle",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "JOB_TITLE",
                                "responseRequired": true
                            },
                            {
                                "questionId": 556417,
                                "question": {
                                    "localized": {
                                        "en_US": "Company name"
                                    }
                                },
                                "responseEditable": true,
                                "name": "company",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "COMPANY_NAME",
                                "responseRequired": true
                            }
                        ],
                        "description": {
                            "localized": {
                                "en_US": "Share your information below with SoftExpert - Software for Excellence to be contacted with more information",
                                "pt_BR": "Compartilhe suas informações abaixo com a organização SoftExpert - Software for Excellence para receber mais informações"
                            }
                        },
                        "legalInfo": {
                            "consents": [
                                {
                                    "consent": {
                                        "localized": {
                                            "en_US": "SoftExpert - Software for Excellence may contact me via email",
                                            "pt_BR": "A organização SoftExpert - Software for Excellence pode entrar em contato comigo por e-mail"
                                        }
                                    },
                                    "checkRequired": true,
                                    "id": 1
                                }
                            ],
                            "legalInfoId": 9999,
                            "privacyPolicyUrl": "",
                            "legalDisclaimer": {
                                "localized": {
                                    "en_US": "SoftExpert - Software for Excellence may use your name and email address to send you communications about the company's products.",
                                    "pt_BR": "A organização SoftExpert - Software for Excellence pode usar seu nome e e-mail para enviar comunicados a você sobre os produtos da empresa."
                                }
                            }
                        },
                        "headline": {
                            "localized": {
                                "en_US": "Contact SoftExpert - Software for Excellence",
                                "pt_BR": "Entrar em contato com a organização SoftExpert - Software for Excellence"
                            }
                        }
                    },
                    "creationLocale": {
                        "country": "BR",
                        "language": "pt"
                    }
                },
                "leadType": "COMPANY",
                "leadMetadataInfo": {},
                "associatedEntityInfo": {
                    "associatedCompany": {
                        "organizationUrn": "urn:li:organization:2222222222"
                    }
                },
                "versionedLeadGenFormUrn": "urn:li:versionedLeadGenForm:(urn:li:leadGenForm:222222222222222222222222,1)",
                "ownerInfo": {
                    "organizationInfo": {
                        "organizationUrn": "urn:li:organization:222222222222222"
                    }
                },
                "id": "22222222222222222",
                "submittedAt": 22222222222222,
                "testLead": false,
                "formResponse": {
                    "consentResponses": [
                        {
                            "accepted": true,
                            "consentId": 1
                        }
                    ],
                    "answers": [
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "jornalistets@.com"
                                }
                            },
                            "questionId": 558345
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "Eduardo"
                                }
                            },
                            "questionId": 558337
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "  Guedin"
                                }
                            },
                            "questionId": 2222
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "Analista de marketing digital"
                                }
                            },
                            "questionId": 560961
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "SoftExpert - Software for Excellence"
                                }
                            },
                            "questionId": 556417
                        }
                    ]
                }
            }
        ]
    },
    "fileSize": 7158
}

]

Sorry, we can’t use that as it isn’t valid JSON (checked when pasted into https://jsonformatter.org)

1.

Could you format your JSON by editing three backticks ``` before and after the entire code (not in the middle), like this:

```
output bundle goes here
```

2.

or use the format code button in the editor:
Screenshot_2023-10-02_191027

3.

Alternatively, you can paste and save the contents of the bundles in your text editor as a .json file, and upload it here into this discussion thread.

3 Likes

ok, json correct

[
    {
        "paging": {
            "start": 0,
            "count": 10,
            "links": [],
            "total": 2
        },
        "elements": [
            {
                "form": {
                    "name": "LeadGen form for SoftExpert - Software for Excellence",
                    "hiddenFields": [
                        {
                            "name": "Entity name",
                            "value": "SoftExpert - Software for Excellence"
                        }
                    ],
                    "id": "1111111111111",
                    "content": {
                        "questions": [
                            {
                                "questionId": 11111111111,
                                "question": {
                                    "localized": {
                                        "en_US": "First Name"
                                    }
                                },
                                "responseEditable": false,
                                "name": "firstName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 350
                                    }
                                },
                                "predefinedField": "FIRST_NAME",
                                "responseRequired": true
                            },
                            {
                                "questionId": 1111111111,
                                "question": {
                                    "localized": {
                                        "en_US": "Last Name"
                                    }
                                },
                                "responseEditable": true,
                                "name": "lastName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "LAST_NAME",
                                "responseRequired": true
                            },
                            {
                                "questionId": 11111111111,
                                "question": {
                                    "localized": {
                                        "en_US": "Email Address"
                                    }
                                },
                                "responseEditable": false,
                                "name": "email",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "EMAIL",
                                "responseRequired": true
                            },
                            {
                                "questionId": 1111111111111,
                                "question": {
                                    "localized": {
                                        "en_US": "Job title"
                                    }
                                },
                                "responseEditable": false,
                                "name": "jobTitle",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "JOB_TITLE",
                                "responseRequired": true
                            },
                            {
                                "questionId": 11111,
                                "question": {
                                    "localized": {
                                        "en_US": "Company name"
                                    }
                                },
                                "responseEditable": true,
                                "name": "company",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "COMPANY_NAME",
                                "responseRequired": true
                            }
                        ],
                        "description": {
                            "localized": {
                                "en_US": "Share your information below with SoftExpert - Software for Excellence to be contacted with more information",
                                "pt_BR": "Compartilhe suas informações abaixo com a organização SoftExpert - Software for Excellence para receber mais informações"
                            }
                        },
                        "legalInfo": {
                            "consents": [
                                {
                                    "consent": {
                                        "localized": {
                                            "en_US": "SoftExpert - Software for Excellence may contact me via email",
                                            "pt_BR": "A organização SoftExpert - Software for Excellence pode entrar em contato comigo por e-mail"
                                        }
                                    },
                                    "checkRequired": true,
                                    "id": 0
                                }
                            ],
                            "legalInfoId": 111111111111111,
                            "privacyPolicyUrl": "https://www.softexpert.com/pt-br/politica-privacidade/",
                            "legalDisclaimer": {
                                "localized": {
                                    "en_US": "SoftExpert - Software for Excellence may use your name and email address to send you communications about the company's products.",
                                    "pt_BR": "A organização SoftExpert - Software for Excellence pode usar seu nome e e-mail para enviar comunicados a você sobre os produtos da empresa."
                                }
                            }
                        },
                        "headline": {
                            "localized": {
                                "en_US": "Contact SoftExpert - Software for Excellence",
                                "pt_BR": "Entrar em contato com a organização SoftExpert - Software for Excellence"
                            }
                        }
                    },
                    "creationLocale": {
                        "country": "BR",
                        "language": "pt"
                    }
                },
                "leadType": "COMPANY",
                "leadMetadataInfo": {},
                "associatedEntityInfo": {
                    "associatedCompany": {
                        "organizationUrn": "urn:li:organization:11111111111111"
                    }
                },
                "versionedLeadGenFormUrn": "urn:li:versionedLeadGenForm:(urn:li:leadGenForm:111111111111,0)",
                "ownerInfo": {
                    "organizationInfo": {
                        "organizationUrn": "urn:li:organization:111111"
                    }

                },
                
                "id": "1111111111111",
                "submittedAt": 1111111111111,
                "testLead": false,
                "formResponse": {
                    "consentResponses": [
                        {
                            "accepted": true,
                            "consentId": 1
                        }
                    ],
                    "answers": [
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste@gmail.com"
                                }
                            },
                            "questionId": 11111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste"
                                }
                            },
                            "questionId": 11111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste"
                                }
                            },
                            "questionId": 11111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste de marketing"
                                }
                            },
                            "questionId": 1111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "SoftExpert - Software for Excellence"
                                }
                            },
                            "questionId": 1111
                        }
                    ]
                }
            },
            {
                "form": {
                    "name": "LeadGen form for SoftExpert - Software for Excellence",
                    "hiddenFields": [
                        {
                            "name": "Entity name",
                            "value": "SoftExpert - Software for Excellence"
                        }
                    ],
                    "id": "111111111",
                    "content": {
                        "questions": [
                            {
                                "questionId": 11111111,
                                "question": {
                                    "localized": {
                                        "en_US": "First Name"
                                    }
                                },
                                "responseEditable": true,
                                "name": "firstName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "FIRST_NAME",
                                "responseRequired": true
                            },
                            {
                                "questionId": 111111,
                                "question": {
                                    "localized": {
                                        "en_US": "Last Name"
                                    }
                                },
                                "responseEditable": false,
                                "name": "lastName",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "LAST_NAME",
                                "responseRequired": true
                            },
                            {
                                "questionId": 11111,
                                "question": {
                                    "localized": {
                                        "en_US": "Email Address"
                                    }
                                },
                                "responseEditable": true,
                                "name": "email",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "EMAIL",
                                "responseRequired": true
                            },
                            {
                                "questionId": 11111,
                                "question": {
                                    "localized": {
                                        "en_US": "Job title"
                                    }
                                },
                                "responseEditable": false,
                                "name": "jobTitle",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 111
                                    }
                                },
                                "predefinedField": "JOB_TITLE",
                                "responseRequired": true
                            },
                            {
                                "questionId": 111111,
                                "question": {
                                    "localized": {
                                        "en_US": "Company name"
                                    }
                                },
                                "responseEditable": false,
                                "name": "company",
                                "questionDetails": {
                                    "textQuestionDetails": {
                                        "maxResponseLength": 300
                                    }
                                },
                                "predefinedField": "COMPANY_NAME",
                                "responseRequired": false
                            }
                        ],
                        "description": {
                            "localized": {
                                "en_US": "Share your information below with SoftExpert - Software for Excellence to be contacted with more information",
                                "pt_BR": "Compartilhe suas informações abaixo com a organização SoftExpert - Software for Excellence para receber mais informações"
                            }
                        },
                        "legalInfo": {
                            "consents": [
                                {
                                    "consent": {
                                        "localized": {
                                            "en_US": "SoftExpert - Software for Excellence may contact me via email",
                                            "pt_BR": "A organização SoftExpert - Software for Excellence pode entrar em contato comigo por e-mail"
                                        }
                                    },
                                    "checkRequired": false,
                                    "id": 0
                                }
                            ],
                            "legalInfoId": 1111111111111111,
                            "privacyPolicyUrl": "https://www.softexpert.com/pt-br/politica-privacidade/",
                            "legalDisclaimer": {
                                "localized": {
                                    "en_US": "SoftExpert - Software for Excellence may use your name and email address to send you communications about the company's products.",
                                    "pt_BR": "A organização SoftExpert - Software for Excellence pode usar seu nome e e-mail para enviar comunicados a você sobre os produtos da empresa."
                                }
                            }
                        },
                        "headline": {
                            "localized": {
                                "en_US": "Contact SoftExpert - Software for Excellence",
                                "pt_BR": "Entrar em contato com a organização SoftExpert - Software for Excellence"
                            }
                        }
                    },
                    "creationLocale": {
                        "country": "BR",
                        "language": "pt"
                    }
                },
                "leadType": "COMPANY",
                "leadMetadataInfo": {},
                "associatedEntityInfo": {
                    "associatedCompany": {
                        "organizationUrn": "urn:li:organization:11111111111111"
                    }
                },
                "versionedLeadGenFormUrn": "urn:li:versionedLeadGenForm:(urn:li:leadGenForm:1111111111111111,0)",
                "ownerInfo": {
                    "organizationInfo": {
                        "organizationUrn": "urn:li:organization:111111111111"
                    }
                },
                "id": "111111111111",
                "submittedAt": 111111,
                "testLead": true,
                "formResponse": {
                    "consentResponses": [
                        {
                            "accepted": false,
                            "consentId": 0
                        }
                    ],
                    "answers": [
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste@hotmail.com"
                                }
                            },
                            "questionId": 1111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste"
                                }
                            },
                            "questionId": 1111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste teste teste"
                                }
                            },
                            "questionId": 11111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "teste de marketing digital"
                                }
                            },
                            "questionId": 11111
                        },
                        {
                            "answerDetails": {
                                "textQuestionAnswer": {
                                    "answer": "SoftExpert - Software for Excellence"
                                }
                            },
                            "questionId": 11111
                        }
                    ]
                }
            }
        ]
    }
]

Confirm with me to see if the json is now correct

The JSON is correct now. Which getresponse module are you using?

3 Likes

you can select create contact

1.

You need to use an iterator to iterate the elements[] array

Screenshot_2023-10-10_221056

2.

Then, you need to expand to the answer, then enter the number 1 for email, 2 for name, etc.

2 Likes

I just did it in a slightly different format, I used map to separate the data into packages, after using an iterator to separate these packages and then using set multiple variables, to get name, email, etc… follow the example below:


iterator:

tools set multiple vatiables:

2 Likes