I'm using a non-standard API response pattern to group my import data into rows. [5301043caa20740200000001-7e97d7d6ce3644d592f1d0da23acca87.png] I shouldn't need to use the one-to-many as the data is now grouped into an array of arrays. In the preSave function on this lookup the options.data,…

@nicholaswhite are you generating an Amazon report, then grabbing the results of the report? If so, why not have all this setup on the initial source step and utilize async helper?

@tylerlamparter Thanks for checking this! I'll be grabbing a report that's already been generated in Amazon on a schedule so I don't need to send a request and wait for the report to generate.

@nicholaswhite when using a lookup, the result mapping will always tie back to the initial record count that came from the source side of the flow. For your example, you have 1 record from the source, which is the completed report details, then you have a lookup to get all the results of the documen…

Thanks @tylerlamparter More than happy to set up number 2. That would definitely work. Do you have an article on using dynamic settings fields/updating the settings based on the value from a flow's data? I have not been able to find any articles on this.

@nicholaswhite it would look something like this ( also here is the integration zip file ): [5301043caa20740200000001-1936d040593e45b885c8b3daa2d98212.png] [5301043caa20740200000001-71c8077940b44ee6857e28614155fd48.png] [5301043caa20740200000001-f3257256b108480988e9f37b79caf717.png] …

Absolutely glorious, Thank you @tylerlamparter . That worked perfectly.

Tyler - I'm struggling to understand how to customize this code for Hubspot. I'm assuming this is custom for Amazon and would need to be modified for HubSpot? My flow would look something like this (I think!): Flow 1: Export company properties from HubSpot > Integrator.io Flow 2: Get companies > …

One to Many using non-standard api response pattern on a CSV

Integrator.io

tylerlamparter (Tyler Lamparter) October 31, 2023, 10:57pm 8

@nicholaswhite I have an updated method on another thread. Here you go! https://connective.celigo.com/t/amazon-settlement-200k-lines-file/318

Topic		Replies	Views
How to export HTTP response as individual records Integrator.io export , lookup	7	231	September 10, 2025
One-to-Many Import not importing any records Integrator.io http , netsuite , import , export , lookup	4	221	March 21, 2024
Layering new source data fields to existing arrayed payload Integrator.io export , lookup , google-sheets , microsoft-dynamics-365-business-central	5	178	October 19, 2023
Group Multiple Records Integrator.io transformation , grouping , salesforce	6	402	August 12, 2024
Responses greater than 5MB and how Integrator.io lookup , listener	7	138	June 26, 2026

One to Many using non-standard api response pattern on a CSV

Related topics