NocoDB a Open Source Airtable Alternative

[Peter]

I guess you can not. Your url has to look something like

http://appname.herokuapp.com/nc/test_R9-9/api/v1/test

You can generate your url even from the Swagger API Doc

Then you have to replace the localhost bit piece with your url

http://appname.herokuapp.com/

In my example app the bit after the domain name looks like

nc/drugs_xScL/api/v1/drugs?fields=Middel%2CBewustzijn%2C(Bij)naam%2CUiterlijk%2CBron%2CWerking%2CGebruikersmethode%2CWerkingsduur%2CRisico's%2CWisselwerking%2CWet%2CMarktprijs%2CGewenning%2CAfhankelijkheid%2CAantoonbaar%20in%20urine%2C%20Afbeelding&limit=100

[Tuto_Futo]

I did the same but after replacing Local host with Heroku link, it's show a error(not log in)

[Peter]

Never tested from Heroku. Did you generate an api key?

[Tuto_Futo]

Yes I generated, when I test on Local machine it working properly,but when I run in Heroku it's not working....

[KevinWang]

I tested on Heroku, it works fine.
But how to write the where condition when try to GET/filter some records?
I did not find any doc for that.

[Know_About_IT]

Thanks for this @Peter Great idea and easy to deploy

[Peter]

I guess you could use this one from the swagger api doc page.

The swagger api doc page is great to format your url.

[KevinWang]

Thanks Peter,
but my question is for the where expression, what's the valid syntax?
I have tried syntax in AirTable like name is "Kevin" and FIND("Kevin",name)>0 and name like "Kevin", but it does not work

[Peter]

Didn't test that yet. Have a lot to test i see

If i use the swagger api doc page i can generate a url like this from my drugs database

http://localhost:8080/nc/drugs_xScL/api/v1/drugs/findOne?fields=Middel&where=XTC%20-%20MDMA

You could make that url with join text blocks.

[Kevinkun]

Have you test the url? Normally the where clause should return a logic value.

[Peter]

It should return json with the data fetched. But likw i said I havent tested this. Next week i will have more time.

[Peter]

Now i tested it.

You should use the api calls from here
https://www.xgenecloud.com/en/v0.5/rest-apis/rest-apis-generated/

https://www.xgenecloud.com/en/v0.5/rest-apis/rest-apis-generated/#query-params

for example

http://localhost:8080/nc/drugs_xScL/api/v1/drugs?fields=Middel&where=(Middel%2Ceq%2CCannabis)

In my case it would return
[{"id":7,"Middel":"Cannabis"}]

[Peter]

I tried also Baserow.io. Another open source airtable alternative. The json produced is more complex then that of nocodb.

The red squares contain one item. Baserow makes multiple thumbnails of my image.

[Kevinkun]

Thanks Peter. now i know the syntax of where clause.

[Hmmm]

@Peter Is there any extension for this just like baserow?
I have also installed this on my local server planning to make something with it but the json barrier is stopping me.

[Peter]

Not that i know of, but you can always use the web component like in the example. I switched to Baserow completely and I am running that on my own server. (with the help of my son @bartmathijssen )

[Hmmm]

I also want to run baserow on my server but they have provided very bad installation options I don't want to install that docker headache on my server.

[Peter]

@Hmmm

docker headache

Then you will have to find another way. In my case it went really well with using one of the Docker images. And you can get support on the Baserow community if you run in any problem.