Alright script masters: I am trying to use the qu...
# suitescriptm
Mike Casey
12/12/2023, 4:37 PMAlright script masters: I am trying to use the query module to return results. I am using .asMappedResults(). When I stringify the variable and log it, it shows up as a stringified array of results. But as soon as I pass it to my back end with the Http module, an empty object is passed to my server. Any ideas what I am doing wrong?
e
erictgrubaugh
12/12/2023, 4:50 PMWill need to see the relevant code
m
Mike Casey
12/12/2023, 4:52 PMe
erictgrubaugh
12/12/2023, 4:57 PMSuiteScript side looks fine. Does your endpoint perhaps expect a specific
Content-Typem
Mike Casey
12/12/2023, 4:57 PMthe other strange thing is if I pass it mappedResults[0] it will pass the first object in the array like normal.
Mike Casey
12/12/2023, 4:57 PMi will give it a try
e
erictgrubaugh
12/12/2023, 4:58 PMWould typically expect maybe
Content-Type: application/jsonerictgrubaugh
12/12/2023, 4:58 PMInteresting; so it works with
JSON.stringify(mappedResults[0])m
Mike Casey
12/12/2023, 4:58 PMi dont even have to stringify it
e
erictgrubaugh
12/12/2023, 4:59 PMBut sending the Array without stringifying doesn't work?
m
Mike Casey
12/12/2023, 4:59 PMnope
e
erictgrubaugh
12/12/2023, 4:59 PModd
m
Mike Casey
12/12/2023, 4:59 PMvery
a
Anthony OConnor
12/12/2023, 5:00 PMis it? if the body starts with [ instead of { then it wont parse will it?
a
alien4u
12/12/2023, 5:01 PMCan you pass a hard coded array of objects (simple one) to your end point?
e
erictgrubaugh
12/12/2023, 5:01 PMAn Array is a valid top-level JSON structure
a
alien4u
12/12/2023, 5:02 PMMaybe your end point is expecting an Object and not an array of objects, normally it should work as @erictgrubaugh mentioned, but not sure if your endpoint side code is doing something non standard.
m
Mike Casey
12/12/2023, 5:03 PMWhen I wrap the stringified in []
Mike Casey
12/12/2023, 5:03 PMcontent type to json did not help
Mike Casey
12/12/2023, 5:05 PMalright i think i got this figured out
Mike Casey
12/12/2023, 5:07 PMMike Casey
12/12/2023, 5:07 PMthis passes as a string just fine
Mike Casey
12/12/2023, 5:08 PMmakes sense if the body is expecting JSON object
👍 1
a
Anthony OConnor
12/12/2023, 5:10 PMyou're welcome 😛
👏 1
m
Mike Casey
12/12/2023, 6:29 PMlol definitely guys thank you! Led me in the right direction!
😉 1
r
reptar
12/13/2023, 4:23 PM@erictgrubaugh @alien4u While an array is a valid JSON object, I have noticed with APIs such as
Renderer.addCustomDataSource()[{"arr": [...]}✅ 2