I have the following as output from an HTTPS API. I'm trying to use it to import items into Netsuite. I have an Input Hook that removes the "first record" which is the column headers. This allows me to get 1 item in but it only does 1 and there isn't an error. Looking for ideas on what I need to change to have all the exported records to be processed.
Here's the export object, I'm getting from the API.
{
"page_of_records": [
{
"record": {
"masterVariables": {},
"data": [
[
"Product ID",
"Description",
"Std packing",
"Duration",
"Caliber",
"Status",
"Category",
"Hazardous\nmaterial",
"Average cost",
"Product Url"
],
[
"518245",
"3\" Finale to be Tied for Show ",
1,
null,
"3\"",
"Active",
"3 Inch Finale",
null,
null,
"/zambellifireworks/api/product/518245"
],
[
"NEO3TESTPRODUCT",
"This is my description",
null,
null,
null,
"Active",
"4 Inch",
null,
null,
"/zambellifireworks/api/product/NEO3TESTPRODUCT"
],
[
"PatDummy1",
"Test Test Test",
72,
3,
"3\"",
"Active",
"3 Inch",
"UN0335",
null,
"/zambellifireworks/api/product/PatDummy1"
]
]
}
}
]
}