Has anyone had success with using Excel VBA to pull saved search results from a NetSuite Restlet? I have the Restlet working fine in PostMan and I am using Web-VBA for the authentication piece in my Excel VBA project. I got the authentication working but the response I am getting when I execute the request is...
"error code: JS_EXCEPTION
error message:{"type":"error.SuiteScriptError","name":"INVALID_RETURN_DATA_FORMAT","message":"Invalid data format. You should return TEXT.","stack":["createError(N/error)"],"cause":{"name":"INVALID_RETURN_DATA_FORMAT","message":"
The content type is set to "application/json" which is the same as I use in PostMan.
I thought that the authentication would be the pain doing this but that is working and I cannot seem to find a solution to this...