Forum Discussion

ChristopherWhe2's avatar
ChristopherWhe2
Qrew Trainee
5 years ago

Uncaught TypeError: JSON.Stringify is not a function

Hello, I'm trying to utilize the new REST API and am getting an error when I call the below script, which I've put in a code page. Am I missing something simple here? --- var headers = { 'QB-Realm...
APIs and custom code
ChristopherWhe2's avatar
ChristopherWhe2
Qrew Trainee
5 years ago
Neil,

I did. The top section is now like below. Info in {XXXXXX} does contain the real values in the code page, I've obscured them here for security:

var body = {"from":"{XXXXXXXX}","select":[20,22,23,24,25,29,31,33],"where":"{'6'.Ex.'Yes'}AND{'20'.Ex.'New York'}"};

var headers = {
'QB-Realm-Hostname': '{XXXXXXXX}',
'Authorization': 'QB-USER-TOKEN {XXXXXXXX}',
'Content-Length': body.length,
'Content-Type': 'application/json'
}

------------------------------
Christopher Wheatley
------------------------------
ChristopherWhe2's avatar
ChristopherWhe2
Qrew Trainee
5 years ago
Hi Neil,

I figured it out after a response from QuickBase support.  The 'data' key in the fetch() method should be 'body' not 'data' now it works great!  I tried with and without the Content-Length header and both ways are working.  Thanks for your help!

------------------------------
Christopher Wheatley
------------------------------
  • NeilSchneider's avatar
    NeilSchneider
    Qrew Cadet
    5 years ago
    No problem.  If you're doing a lot of testing you might want to take a look at Postman, it lets you set up and test an API without any coding...

    ------------------------------
    Neil Schneider
    ------------------------------