Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 07, 2020 01:14 PM
I have data that I can transfer in API form.
All I have to do is give the endpoint API. How do I do that? I have the data in the form of a table
Apr 19, 2020 04:39 AM
??? yes or no ? can u help me
May 02, 2020 04:53 PM
You might have better luck in getting a reply if you say a little more about your situation. What have you done with the API so far?
Have you looked at the documentation at https://airtable.com/api? It describes how you can create and update records.
May 03, 2020 07:28 AM
Hi @Merten_Ser
To echo @kuovonne’s point, the API is very well documented, You can go to https://airtable.com/api, choose your base, and you can literally navigate to the endpoint you need
May 08, 2020 01:33 PM
Thanks, but I’m not sure how I can get data from any cell. Let’s say I have Field 7 and Field 8.
in the example “Retrieve a Table 1 record” i can only get post with ID ??
like : https://api.airtable.com/v0/apxxxxxxxxP/Table%201/dasgasdsaxxxx
how to get every row from Field 7 and 8 for instance ?
May 09, 2020 11:00 AM
If you want to retrieve data for only a single record, based on the record ID, make a GET request to the record endpoint.
https://api.airtable.com/v0/appxxxxxxx/TableName/recxxxxxxxxxxx
Notice that the record endpoint ends with the record id, which is the internal record id that starts with rec
, not the value of the primary field. This value can be retrieved with the RECORD_ID()
function in the user interface.
This should give you all the fields for the record that are not blank. If the desired fields are blank, you will not get a result.
If you want to retrieve data for specific fields for multiple records, make a GET request to the table endpoint.
https://api.airtable.com/v0/appxxxxxxx/TableName
Normally all non-blank fields are returned, but you can limit the fields returned to specific fields. You can see more details in the API documentation for controlling the records return by view, sort, or filter.
Again, the API will not return blank values.