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
Thanks, Neil!  I've updated the code and now I'm getting a 400 error:

"https://api.quickbase.com/v1/records/query 400 (Bad Request)"

I've reached out to QuickBase support, hopefully they can help.  The original code came from their API guide so they're now aware of the typo.

Best,

Chris

------------------------------
Christopher Wheatley
------------------------------
NeilSchneider's avatar
NeilSchneider
Qrew Cadet
5 years ago
Chris,
Did you add the Content-Length header?  You'll get an error 400 if that header isn't present.
Also I'm assuming you are replacing the curly bracket enclosed items with the actual values, for example:
'QB-Realm-Hostname': yoursite.quickbase.com
'Authorization': 'QB-USER-TOKEN xxxxxx_xxxx_xxxxxxxxxxxxxxxxxxxxxxxxxx',  -where xxx... is a token for your app
"from": "XXXXXXXXX",  - where XXX... is the internal table name
Neil

Neil

------------------------------
Neil Schneider
------------------------------
  • 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
        ------------------------------
    • NeilSchneider's avatar
      NeilSchneider
      Qrew Cadet
      5 years ago
      Chris,
      The length needs to be the length of the string created by JSON.stringify.  Try this:
      var body = {"from":"{XXXXXXXX}","select":[20,22,23,24,25,29,31,33],"where":"{'6'.Ex.'Yes'}AND{'20'.Ex.'New York'}"};
      var bodyToSend = JSON.stringify(body);
      ....
      'Content-Length' : bodyToSend.length
      ...
      data: bodyToSend






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