Skip to main content

Simple POST Script error 'SyntaxError: Unexpected token C in JSON at position 0,,'


Forum|alt.badge.img+6

Hi,

I have added a fairly simple scripting block that accesses an endpoint on my application. The error when running this is below, but can’t for the life of me work out what this is referring to.

Has anyone got any ideas?

ERROR

SyntaxError: Unexpected token C in JSON at position 0

at Unexpected token C in JSON at position 0

let token = await input.textAsync("Insert Token")
let table = base.getTable("test");
let record = await input.recordAsync('Pick a record',table)
let initialRaw = record.getCellValue("updatedcontent")
let recordid = "60cf7b6133fed78cdae3ca48"

let env = await input.buttonsAsync('Choose Environment', 
['Test', 
'Live'])
var exampleRequest = {
    "items":[
        {"ID":"1234",
        "name":"Mr Smith"};
        
var exampleRaw = JSON.stringify(exampleRequest)
let raw = JSON.stringify(initialRaw)
let url=''
if (env=='live')
    {
        url= 'https://live.com/user/'+recordid
    }
else
    {
        url='https://test.com/user/'+recordid
    }

console.log(url)
console.log(initialRaw)
console.log(raw)
console.log(exampleRequest)
console.log(exampleRaw)

//POST API LOCATION call
    var myHeaders = new Headers();
    myHeaders.append("Authorization", "Bearer "+token);
    myHeaders.append("Content-Type", "application/json")
    myHeaders.append("Accept", "application/json")
    
    var requestPostOptions = {
        method: 'POST',
        headers: myHeaders,
        redirect: 'follow',
        body: exampleRaw
        };
    console.log(requestPostOptions)
    let orderResponse = await fetch(url, requestPostOptions);
    let finalResponse = await orderResponse.json()
    console.log(finalResponse)

3 replies

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6006 replies
  • July 21, 2021

When you set exampleRequest you are missing a closing ] and a closing }

var exampleRequest = {
    "items":[
        {"ID":"1234",
        "name":"Mr Smith"}
    ]
};
        
var exampleRaw = JSON.stringify(exampleRequest)

Forum|alt.badge.img+6
  • Author
  • New Participant
  • 4 replies
  • July 21, 2021
kuovonne wrote:

When you set exampleRequest you are missing a closing ] and a closing }

var exampleRequest = {
    "items":[
        {"ID":"1234",
        "name":"Mr Smith"}
    ]
};
        
var exampleRaw = JSON.stringify(exampleRequest)

Hi,

Thanks very much, but this error was just part of me trimming the JSON down to an example format.

The syntax error still shows, not sure what it could be?


Forum|alt.badge.img+3
  • Participating Frequently
  • 59 replies
  • July 22, 2021
Ewan_Farry wrote:

Hi,

Thanks very much, but this error was just part of me trimming the JSON down to an example format.

The syntax error still shows, not sure what it could be?


The error indicates JSON parsing is failing somewhere. The only place where JSON is being parsed in your example is this line:

let finalResponse = await orderResponse.json()

Can you check whether the response from your api is valid JSON? E.g. by logging this:

console.log(orderResponse.text());

Reply