Exclude/Include Fields in API Call

[artoflogic]

I am not sure if the documentation is correct here:
https://api.baserow.io/api/redoc/#tag/Database-table-grid-view/operation/public_list_database_table_grid_view_rows

In the Documentation of my Specific Database, it says the exact opposite. “Include” would select the fields to display, not the field options.

In any case, it didn’t work for me. I tried to enter this criterion in the query string part in Make.com but to no avail. The API Call would still return the whole dataset with ALL fields.

Any ideas?

[petrs]

Hi @artoflogic,

you are looking at the documentation for two different endpoints.

@artoflogic

https://api.baserow.io/api/redoc/#tag/Database-table-grid-view/operation/public_list_database_table_grid_view_rows

^This endpoint is for a grid view while the Baserow documentation for your database is a " List rows" endpoint. They are not the same.

First decide which endpoint you need and want to use as the public grid view one is for unauthenticated access. Then we can sort out the parameter. One thing that I see in you example is that you don’t use the proper field name (“field_123”) in the value. So that can be an issue.

[artoflogic]

Thank you @petrs .

Ok that makes sense. I overlooked that. Will recheck this. Thank you.

[artoflogic]

Dear @petrs ,

I tested this a bit more but this is still not very clear. I am trying to only extract 4 columns from the database for my search query.

1. The documentation says to add the include parameter.
   Welcome back | Baserow
   

   

2. This seems similar to this issue, only that I am using Field IDs but not Field Names
   GET API with Query parameters "include" and "exclude" data response is not as expected - #2 by frederikdc

3. So I am adding a parameter Include to only output 4 columns (+ default columns)
   

   

4. I still get an error message
   

   

5. If I remove the include parameter, my query works but will time out since on column field contains too large data.

Please advise on how to fix this.

[petrs]

Which endpoint are you trying to use?

Can you paste your exact URL here (or send in DM) that you think should work?

[artoflogic]

Dear @petrs

The API Endpoint URL is https://api.baserow.io/api/database/rows/table/[TABLEID]/

I am following the instructions as per the Specs of my Database
https://baserow.io/api-docs/database/[TableID]

See List Rows Documentation. Only I don’t want to use Field Names, I am using Field IDs, so I don’t use the last query parameter in the URL.

I think I am applying the Include Parameter wrong. I would need to know how to do this correctly in Make.com

[petrs]

OK so the URL should look like https://api.baserow.io/api/database/rows/table/9/?include=field_96,field_97 for example, replacing the table and field Ids. Can you verify what the final requests look like in Make?

[artoflogic]

@bram @petrs

I tested with Postman how to create an API call that would only include 2 select fields and use the filters criteria.

I got the include parameter to work. But there is a bug or something strange in the Baserow API when we enter 2 query parameters, named include and filters the request fails. But it works fine when it is passed separately (either include and filters, then the API call works)

I checked this with Make.com support - just testing the API call in Postman.co - without going into Make.com scenarios and they also tell me, that from the Baserow API documentation, it is not very clear how to pass both the query parameters together.

Please clarify how you can use both, the include and filters parameter in one API call together in one API call.

[petrs]

As answered in the private message I think all the fields that you want to filter need to be included via the include parameter.

[artoflogic]

Yes, you are right. I am filtering for another field ID, that was not included in the Include Statement.

When I add the additional field Id to the list of IDs specified in the Inlcude section, indeed the API call works now.

This is great! Thank you so much!