Hello,
I'm building a flow that exports order information from BigCommerce into NetSuite.
The source is a webhook from BigCommerce that provides the flow with the order ID.
From there I'm branching into several API lookups to fetch order information concurrently. All of the branches are always executed (there are no conditions). The issue that I'm facing is being unable to merge all payloads together
When previewing the field mapping at the NetSuit import node, I can see this:
But in reality, that node does not receive 1 combined payload, it actually receives all N payloads, each one comprised of the base to keys (order_id and store_hash), plus the key that each individual API call produced. IE:
{
"order_id": 123,
"store_hash": "ABC",
"data": {...}
},
{
"order_id": 123,
"store_hash": "ABC",
"taxes": {...}
},
How can I aggregate these N different payloads into a single one, as shown on the field mapping?
@pedropeixoto Since your query concerns with building a custom flow, I am moving your query to the Troubleshoot custom flows community section for a better reach. The BigCommerce – NetSuite Integration App community section is for queries related to the flows within the integration app.
@pedropeixoto branching won't work for what you're trying to do here because there is no way to merge records back together as a single record after they have been branched off. When you create a branch that uses "all matching branches", the single order record now becomes N order records where N is the number of branches you have. As you have it now, once you get to the NetSuite step, you have 4 records for a single order and each record has a single lookup piece of information. Those orders are also spread across different pages of data since that's how we process records through execution steps.
You'll have to make these linear without branching. I would also suggest you go through these articles to increase the performance of the flow as it seems like that's what you're trying to do.
