Hi everyone,
I’m building a Make.com scenario to generate a full Apollo.io People Search URL based on data coming from a webhook. The webhook provides multiple filters such as seniority levels, locations, employee ranges, tags, keywords, and pagination info.
The goal is to
Turn webhook input like this:
{
"page": 1,
"seniority": ["owner", "founder", "c_suite"],
"location": ["United Kingdom"],
"employeeRanges": ["1,10", "11,20"],
"tags": ["SEO", "Site audits"],
"includedKeywordFields": ["tags", "social_media_description"]
}
To end with an Apollo search like this: https://app.apollo.io/#/people?page=1&
personSeniorities[]=owner&
personSeniorities[]=founder&
personSeniorities[]=c_suite&
personLocations[]=United%20Kingdom&
organizationNumEmployeesRanges[]=1%2C10&
organizationNumEmployeesRanges[]=11%2C20&
qOrganizationKeywordTags[]=SEO&
qOrganizationKeywordTags[]=Site%20audits&
includedOrganizationKeywordFields[]=tags&
includedOrganizationKeywordFields[]=social_media_description&
sortAscending=false&
sortByField=recommendations_score
I've realised inside Make I need the final assembly to look something like this:
https://app.apolloio/#/people?page={{1.page}}&{{2.seniorityFinal}}&{{3.locationFinal}}&{{4.employeeRangesFinal}}&{{5.tagsFinal}}&{{6.includedFieldsFinal}}&sortAscending=false&sortByField=recommendations_score
but I’ve been having a lot of trouble with the actual of construction the first variable seniorityFinal.
I hope that makes sense and thanks in advance for your input! If anyone has any tips at all, URL encoding etc, I’d love to hear.