Skip to main content

Hey guys

 

Im trying to create a new Customer in Netsuite but unfortunately I have 2 required Multiple Select fields and I have tried all sorts of lists as suggested everywhere but without any luck I keep getting “Invalid content in the request body.”

From what I have read around I have to provide an array of the Internal IDs, well I have tried the below and doesn't work

["1"]

Any ideas, anyone been successful in doing this?

 

Error

 

Hi ​@ardashla 

For us to have more info about the Zap step error, post screenshots showing how your Zap step 7 is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible so we can see the field types.

 


@Troy Tessalone  - sure thing, pls see below, let me know if you need more, I have added just the field that is the Multiselect, I am 100% sure it is the issue because I was adding the fields one by one to see where the error is:

 

 


@ardashla 

Try sending the data structured as an array:

  • Formatter > Utilities > Line Itemizer
    OR
  • Formatter > Utilities > Text to Line Items

 

Help links about how to use line items in Zaps: https://help.zapier.com/hc/en-us/articles/8496277737997-Use-line-items-in-Zaps

Help link about handling arrays in Zaps: 

 


@Troy Tessalone  like this?

 

 

 

 

 

 


@ardashla 

You probably do not need the brackets [ ] as part of the values.

If you are trying to structure the data as an array use this Zap action: Formatter > Utilities > Text to Line Items

Screenshot below shows what an array output looks like from a Zap step.

 


unfortunately doesn't help, since I have one value the output is always the same its the format that needs sorting for that field, I can't find any documentation on the NetSuite site either all I see is that it needs to be an array

 


@ardashla 

Probably best to reach out to Netsuite Support for help and guidance.


Hey ​@ardashla,

You may also want to try giving the input as a list like “1,2,3” instead of array to see if it fixes it. Also, make sure to use the correct internal ids for multiple select field as some temporary number may also result in an error. Hope it helps!