Error: NoTypeValidates: # StringTooLong: #NullExpected

Integrator.io
, , ,
1

This is what I’m doing in the first step:

I’m using a saved-search pulling data in NetSuite and using that as an export to Celigo

This is what I’m using in the handlebar along with the data being used and the data being previewed.

image
image1166×178 54.1 KB

Despite having the correct output in the handlebar preview, I am getting this error once I populate the Mock Reponse:

image
image853×231 41.8 KB

Error: NoTypeValidates: #/Records {Array: ArrayItemNotValid: #/Records[0] { NoTypeValidates: #/Records[0].Supplier1Code {Null: StringTooLong: #/Records[0].Supplier1Code NullExpected: #/Records[0].Supplier1Code } {String: StringTooLong: #/Records[0].Supplier1Code } } } {Null: ArrayItemNotValid: #/Records[0] { NoTypeValidates: #/Records[0].Supplier1Code {Null: StringTooLong: #/Records[0].Supplier1Code NullExpected: #/Records[0].Supplier1Code } {String: StringTooLong: #/Records[0].Supplier1Code } } NullExpected: #/Records }

Has anyone encountered something similar to this? I checked the field in netsuite and the field has a maximum length of 60. Thank you in advance!

2

The error looks like it says the field can be either null or a string, but the string you provided is invalid (too long). So it falls back to check if it can be null instead — and it wasn’t, so that fails too. Use Handlebars to limit it to 60 characters: {{substring Supplier1Code 0 60}} and try again.