Hello, I’ve not much experience so this might be simple but I have an json REST api that can successfully output data to nocodb but I can’t generate an “id” field to send (it is just a sensor outputting time and temperature). Is there a way to get nocodb to automatically generate the “id” or does the “id” have to be generated externally?
when you create a table in nocodb - we generate an id which is set to autoincrement
Thanks for the response - my problem is that it seems nocoDB requires an “Id” field. I am using REST POST api from a source that can’t send an incrementing “Id” field just sensor values. If I try to send the JSON formatted fields without an “Id” field I get a 400 Error. I guess I’m asking if there is a way for nocoDB to work out that there is no Id value and automatically add one to inputs coming from the POST api. I can add a timestamp field as “Id” but that doesn’t seem to work. Any possible workarounds would be appreciated.
can u pls confirm if you are using this api
it works as you are proposing
and wht are the error like on server side
Hi, yes that is the api I am using. I was trying to follow the example schema from the api documents:Example Value
However when I removed the “Id” and created/updated fields from the JSON I was sending and just sent the values the “Id” was correctly autogenerated. Seems like by adding the created/updated fields I was preventing the “Id” from being autogenerated. I’m sure this might be obvious to others but perhaps the example schema should not include the autogenerated variables? The link you sent about the api didn’t have these so perhaps they should be removed from the examples in the installed version NocoDB: API Docs. Again this may not be a problem for many users but may help inexperience ones like myself! Thanks again for helping to get me on the right path.