Need help with transforming data into an array

Hi. I’m not a developer, so my question might be very simple, however, I’ve been struggling with it for days lol

I need to somehow get all the ID’s from the output and then put each one of them (up to a 100) separately into an array to make a bulk API call.
I’ve entered 2 ID’s as an example.

The next step would be to somehow limit the amount of ID’s in a bulk API call by a 100, and send each 100 of them in separate API calls until I reach the end of the list.

I’m sorry if this sounds confusing. Please ask any questions that might help.
Thank you

Here is the output of the first node:
[
{
“pagination”: {
“start”: 1,
“next”: 11,
“total”: 29
},
“profiles”: [
{
“id”: 177115409,
“status”: “complete”,
“name”: “Al Harrison”,
“profile_pic”: null,
“links”: {
“linkedin”: “https://www.linkedin.com/in/al-harrison-16624815
},
“linkedin_url”: “https://www.linkedin.com/in/al-harrison-16624815”,
“location”: “Solon, OH, US”,
“city”: “Solon”,
“region”: "OH ",
“country”: “United States”,
“country_code”: “US”,
“current_title”: “Product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “Swagelok Company”,
“current_employer_domain”: “swagelok.com”,
“current_employer_website”: “https://www.swagelok.com/”,
“teaser”: {
“emails”: [
swagelok.com
],
“phones”: [],
“preview”: [],
“is_premium_phone_available”: false
},
“birth_year”: 1948,
“current_employer_id”: 11006,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/swagelok”,
“region_latitude”: 41.3897764,
“region_longitude”: -81.4412259,
“suppressed”: false
},
{
“id”: 89373851,
“status”: “complete”,
“name”: “Karan Falco”,
“profile_pic”: null,
“links”: {
“linkedin”: “https://www.linkedin.com/in/karan-falco-a1710711
},
“linkedin_url”: “https://www.linkedin.com/in/karan-falco-a1710711”,
“location”: “New York, United States”,
“city”: “Staten Island”,
“region”: "NY ",
“country”: “United States”,
“country_code”: “US”,
“current_title”: “Product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “Merrill Lynch”,
“current_employer_domain”: “ml.com”,
“current_employer_website”: “http://www.ml.com”,
“teaser”: {
“emails”: [
aol.com”,
ml.com
],
“phones”: [
{
“number”: “212236XXXX”,
“is_premium”: false
}
],
“preview”: [],
“is_premium_phone_available”: false
},
“birth_year”: 1960,
“current_employer_id”: 1178,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/merrilllynch”,
“region_latitude”: 40.5795317,
“region_longitude”: -74.1502007,
“suppressed”: false
},
{
“id”: 298159465,
“status”: “progress”,
“name”: “Joe Beane”,
“profile_pic”: null,
“links”: null,
“linkedin_url”: “https://www.linkedin.com/in/joe-a-beane-63809754”,
“location”: “Auburn, Maine, United States”,
“city”: “Auburn”,
“region”: "ME ",
“country”: “United States”,
“country_code”: “US”,
“current_title”: “Product Compliance”,
“normalized_title”: “unknown normalized title”,
“current_employer”: “Kicteam, Inc”,
“current_employer_domain”: “kicteam.com”,
“current_employer_website”: “http://www.kicteam.com”,
“teaser”: {
“emails”: [
kicteam.com
],
“phones”: [],
“preview”: [],
“is_premium_phone_available”: false
},
“birth_year”: 1975,
“current_employer_id”: 366147,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/kicteam-inc”,
“region_latitude”: 44.0978509,
“region_longitude”: -70.2311655,
“suppressed”: false
},
{
“id”: 474205118,
“status”: “complete”,
“name”: “Lori Lam”,
“profile_pic”: null,
“links”: {
“linkedin”: “https://www.linkedin.com/in/lori-trang-lam-a368001a5
},
“linkedin_url”: “https://www.linkedin.com/in/lori-trang-lam-a368001a5”,
“location”: “San Jose, CA, US”,
“city”: “San Jose”,
“region”: "CA ",
“country”: “United States”,
“country_code”: “US”,
“current_title”: “product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “Thermo Fisher Scientific”,
“current_employer_domain”: “thermofisher.com”,
“current_employer_website”: “http://www.thermofisher.com”,
“teaser”: {
“emails”: [],
“phones”: [],
“preview”: [
“Thermo Fisher Scientific”,
“personal emails”
],
“is_premium_phone_available”: false
},
“birth_year”: null,
“current_employer_id”: 3081,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/thermo-fisher-scientific”,
“region_latitude”: 37.3382082,
“region_longitude”: -121.8863286,
“suppressed”: false
},
{
“id”: 34473457,
“status”: “complete”,
“name”: “Mark Swanson”,
“profile_pic”: “https://d1hbpr09pwz0sk.cloudfront.net/profile_pic/mark-swanson-10e7f603.jpg”,
“links”: {
“linkedin”: “https://www.linkedin.com/in/mark-swanson-a8762778
},
“linkedin_url”: “https://www.linkedin.com/in/mark-swanson-a8762778”,
“location”: “Stevensville, Michigan, United States”,
“city”: “Stevensville”,
“region”: "MI ",
“country”: “United States”,
“country_code”: “US”,
“current_title”: “Product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “Weil-McLain”,
“current_employer_domain”: “weil-mclain.com”,
“current_employer_website”: “http://www.weil-mclain.com”,
“teaser”: {
“emails”: [
gmail.com”,
yahoo.com”,
whirlpool.com
],
“phones”: [
{
“number”: “269428XXXX”,
“is_premium”: true
}
],
“preview”: [],
“is_premium_phone_available”: false
},
“birth_year”: 1968,
“current_employer_id”: 50637,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/weil-mclain”,
“region_latitude”: 42.014487,
“region_longitude”: -86.5194654,
“suppressed”: false
},
{
“id”: 300012755,
“status”: “complete”,
“name”: “Claire Wyndram”,
“profile_pic”: null,
“links”: {
“linkedin”: “https://www.linkedin.com/in/claire-wyndram-627a8284
},
“linkedin_url”: “https://www.linkedin.com/in/claire-wyndram-627a8284”,
“location”: “Portsmouth, England, United Kingdom”,
“city”: “Portsmouth”,
“region”: null,
“country”: “United Kingdom”,
“country_code”: “UK”,
“current_title”: “Product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “British American Tobacco”,
“current_employer_domain”: “bat.com”,
“current_employer_website”: “http://www.bat.com”,
“teaser”: {
“emails”: [
bat.com
],
“phones”: [],
“preview”: [],
“is_premium_phone_available”: false
},
“birth_year”: 1996,
“current_employer_id”: 2291,
“current_employer_linkedin_url”: “https://www.linkedin.com/company/british-american-tobacco”,
“region_latitude”: 50.8197675,
“region_longitude”: -1.0879769,
“suppressed”: false
},
{
“id”: 261947897,
“status”: “complete”,
“name”: “Ana May Matias”,
“profile_pic”: null,
“links”: {
“linkedin”: “https://www.linkedin.com/in/ana-may-matias-79975a175
},
“linkedin_url”: “https://www.linkedin.com/in/ana-may-matias-79975a175”,
“location”: “Manila, National Capital Region, Philippines”,
“city”: “Manila”,
“region”: null,
“country”: “Philippines”,
“country_code”: “PH”,
“current_title”: “Product Compliance”,
“normalized_title”: “Product Safety Compliance Leader”,
“current_employer”: “Citi Regional Headquaters”,
“current_employer_domain”: null,
“current_employer_website”: null,
“teaser”: {
“emails”: [],
“phones”: [],
“preview”: [
“Citi Regional Headquaters”,
“personal emails”
],
“is_premium_phone_available”: false
},
“birth_year”: 1982,
“current_employer_id”: null,
“current_employer_linkedin_url”: null,
“region_latitude”: 14.5995124,
“region_longitude”: 120.9842195,
“suppressed”: false
}
]
},
{
“pagination”: {
“start”: 1,
“next”: 11,
“total”: 0
},
“profiles”: []
}
]

Hi @Artego :wave: Not too sure I’m on the right track, but can the item lists node help you out here?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.