Error while inserting new row [Jun 10]

NocoDB · November 3, 2022, 10:07am

Hello! I’m teaching myself how to insert a new row in the API through Axios. I’m suspecting that I’m formatting the request wrong since it queries for a row instead of inserts. Also all variables are working as I tested these before hands, so that’s why I suspected it’s the way I formatted the request that is wrong. Here’s how it looks so far:

```js

//NocoDB inputting

var create = {

method: ‘POST’,

url: `${sheet_Users}`,

headers: {

‘xc-auth’: process.env.nocodb_token,

},

fields: {

my_reversals: `${inputtingRev}`,

my_faves: `${inputtingFave}`,

random_or_faves: `${inputtingRoF}`,

created_on: new Date().toISOString(),

},

}; // End of create

var inputting

var inputtingrequest = await axios

.request(create)

.then(function (response) {

console.log(`This is the response data for inputting new user:`);

console.log(response.data);

inputting = response.data;

UserRow = response.data.ID;

})

.catch(function (error) {

console.error(error);

});

```

NocoDB · November 3, 2022, 10:07am

can you help us with the error message?

NocoDB · November 3, 2022, 10:07am

Sure! It’s super long though but first of all is the “await axios.request(create)” a correct sentence? I’ve seen people use “await axios.post”

NocoDB · November 3, 2022, 10:07am

axios.request(create) is fine. you will have to replace fields with data: {}

NocoDB · November 3, 2022, 10:07am

```const options2 = {

method: ‘POST’,

url: ‘http://localhost:8080/api/v1/db/data/noco/p_wiukyreqe052rf/Producer/’,

data: { Name: “x1”, Notes: “x1” },

headers: {

‘xc-auth’: authToken

}

};

axios.request(options2).then(function (response) {

console.log(response.data);

}).catch(function (error) {

console.error(error);

});```

NocoDB · November 3, 2022, 10:07am

this worked for me.

NocoDB · November 3, 2022, 10:07am

you can find ready sample code (mapped for read api) on clicking get api snippet on your right bottom of grid view window

NocoDB · November 3, 2022, 10:07am

here

NocoDB · November 3, 2022, 10:07am

Okay! I tried replacing “fields” to “data” instead & while the error message looks a lot shorter now, here’s what it says:

`TypeError [ERR_INVALID_ARG_TYPE]: The "url" argument must be of type string. Received an instance of Object`

I did use a variable for the url, it works for when I’m querying/getting a row

NocoDB · November 3, 2022, 10:07am

try dumping url content to confirm if all good

NocoDB · November 3, 2022, 10:07am

okay just did! pasted the url instead of using the variable where i stored it. still gave me the same TypeError message

NocoDB · November 3, 2022, 10:07am

`${sheet_Users}` : can you dump this? to confirm if its object or a string

NocoDB · November 3, 2022, 10:07am

Wanted to clarify: you “dump” a variable by doing `console.log(variable)` right?

NocoDB · November 3, 2022, 10:07am

yes

NocoDB · November 3, 2022, 10:07am

ah okay good let me share what I got

NocoDB · November 3, 2022, 10:07am

So this is the console log line:

```js

console.log(`This is the line right before NocoDB inputting, sheet_Users looks like: ${sheet_Users}`)```

and this is how it looks like in my log:

`This is the line right before NocoDB inputting, sheet_Users looks like: http://heyheka.herokuapp.com/api/v1/db/data/noco/p_s828dsukkjkkq4/Heka - User Data/views/Heka - User Data/`

NocoDB · November 3, 2022, 10:07am

there are spaces in name. try url: `${encodeURI(sheet_Users)}`,

NocoDB · November 3, 2022, 10:07am

still gave me the same eror

NocoDB · November 3, 2022, 10:07am

Also I just noticed that one of my fields is a single select field? Do I have to input my data differently or can I just write down my selection name?

NocoDB · November 3, 2022, 10:07am

Error while inserting new row [Jun 10]

```js

//NocoDB inputting

var create = {

method: ‘POST’,

url: ${sheet_Users},

headers: {

‘xc-auth’: process.env.nocodb_token,

},

fields: {

my_reversals: ${inputtingRev},

my_faves: ${inputtingFave},

random_or_faves: ${inputtingRoF},

created_on: new Date().toISOString(),

},

}; // End of create

var inputting

var inputtingrequest = await axios

.request(create)

.then(function (response) {

console.log(This is the response data for inputting new user:);

console.log(response.data);

inputting = response.data;

UserRow = response.data.ID;

})

.catch(function (error) {

console.error(error);

});

```

can you help us with the error message?

Sure! It’s super long though but first of all is the “await axios.request(create)” a correct sentence? I’ve seen people use “await axios.post”

axios.request(create) is fine. you will have to replace fields with data: {}

```const options2 = {

method: ‘POST’,

url: ‘http://localhost:8080/api/v1/db/data/noco/p_wiukyreqe052rf/Producer/’,

data: { Name: “x1”, Notes: “x1” },

headers: {

‘xc-auth’: authToken

}

};

axios.request(options2).then(function (response) {

console.log(response.data);

}).catch(function (error) {

console.error(error);

});```

this worked for me.

you can find ready sample code (mapped for read api) on clicking get api snippet on your right bottom of grid view window

here

Okay! I tried replacing “fields” to “data” instead & while the error message looks a lot shorter now, here’s what it says:

TypeError [ERR_INVALID_ARG_TYPE]: The "url" argument must be of type string. Received an instance of Object

I did use a variable for the url, it works for when I’m querying/getting a row

try dumping url content to confirm if all good

okay just did! pasted the url instead of using the variable where i stored it. still gave me the same TypeError message

${sheet_Users} : can you dump this? to confirm if its object or a string

Wanted to clarify: you “dump” a variable by doing console.log(variable) right?

yes

ah okay good let me share what I got

So this is the console log line:

```js

console.log(This is the line right before NocoDB inputting, sheet_Users looks like: ${sheet_Users})```

and this is how it looks like in my log:

This is the line right before NocoDB inputting, sheet_Users looks like: http://heyheka.herokuapp.com/api/v1/db/data/noco/p_s828dsukkjkkq4/Heka - User Data/views/Heka - User Data/

there are spaces in name. try url: ${encodeURI(sheet_Users)},

still gave me the same eror

Also I just noticed that one of my fields is a single select field? Do I have to input my data differently or can I just write down my selection name?

single select, option in quotes. multi select, comma separated string under quotes (example: “option-1, option-2”)

url: `${sheet_Users}`,

my_reversals: `${inputtingRev}`,

my_faves: `${inputtingFave}`,

random_or_faves: `${inputtingRoF}`,

console.log(`This is the response data for inputting new user:`);

`TypeError [ERR_INVALID_ARG_TYPE]: The "url" argument must be of type string. Received an instance of Object`

`${sheet_Users}` : can you dump this? to confirm if its object or a string

Wanted to clarify: you “dump” a variable by doing `console.log(variable)` right?

console.log(`This is the line right before NocoDB inputting, sheet_Users looks like: ${sheet_Users}`)```

`This is the line right before NocoDB inputting, sheet_Users looks like: http://heyheka.herokuapp.com/api/v1/db/data/noco/p_s828dsukkjkkq4/Heka - User Data/views/Heka - User Data/`

there are spaces in name. try url: `${encodeURI(sheet_Users)}`,