I am unable to resolve this issue when mapping fields on an import: “Extension result doesn't contain the same number of elements as the request object. Expected 1, got . Extension returned statusCode 200 error”
I am attempting to create a Bill of Materials Revision record in NetSuite. The BOM Revision includes a list of components. In my source system, Salesforce, the components are composed of two different types of objects. In addition, I need to include static components that don’t exist in Salesforce. These components cannot be accessed directly through related lists but as junction objects.
I am using lookup steps to run SOQL to obtain the additional data from each of the objects and then use Result Mapping to make the additional data available to the import. Mapping the components worked correctly with the first set of components, based on the output of a single lookup step.
But because I need to combine records from multiple lookups, which query different Salesforce objects, and also include static values, I am using a preMap hook script to combine the output of each lookup and the static value and create an additional node in the record: combined_components.
But now when the import step runs, I get the error noted above. I can confirm that the combined_component node in the JSON is being added correctly, but for some reason Celigo refuses to accept the updated record.
