Issue with splitting orders from Mirakl API

[christianbannard]

Hi all,

We're presently setting up a standalone flow for the Mirakl API and have most of it working, including import of the first order record into Netsuite, though when we import an initial batch of orders, it's not splitting the records at the end of each "order", and instead grouping them as one large record.

Therefore when we import the records into Netsuite, we only receive the first order.

As you can see by the screenshot, Celigo is saying there's only one record, rather than reading each of the "orders" and reporting the actual number of records, yet the response from the API says there's actually 260 order records in it.

How do we split the orders so they come through as individual records?

Many thanks and I hope someone can assist with what I think is most likely going to be a fairly easy fix (just that I don't know how to do it).

Regards,

Christian

[tylerlamparter]

@christianbannard as for how to tell IO that the orders array is where the actual records are, you need to specify a "Path to records in HTTP response body".

It also looks like you have a group by setting in place. Is there a reason for that? I would assume you probably don't need that, but don't fully know the response pattern here.

[christianbannard]

Hi @tylerlamparter,

Just wanted to confirm that your suggestion did the trick and we ended up resolving the issue and getting this flow working correctly.

Many thanks for your assistance.

Regards,

Christian