Dev_Local - profile

Dev_Local · Mar 05, 2020

Using the Airtable API, I am sending a timestamp exactly like this (on an insertion of a record/row): {“fields”: {“Some Timestamp”: “2020-03-05 04:00”} } How is this interpreted by Airtable? I want it to be interpreted as: “2020-03-05 04:00 PM UTC”...

Dev_Local · Jan 04, 2020

I have a table/sheet that has a field that links to records in another table (parent/child). When I use the REST API and do a HTTP GET (url, params, headers), and look at the response, the only thing I see in the field with the link is the AT record ...

Dev_Local · Dec 23, 2019

How do I use the REST API to delete ten records at a time using axios? I can successfully delete one record at a time, but due to the API design, I am having a problem constructing the URL to delete ten at a time. Here is what works with one record ...

Dev_Local · Dec 23, 2019

If I have a field customized to this type: 1. Date 2. Time component 3. 12 hr and I use the key/value pair in my JSON/POST, what do I send there to get this to work? I have this working if I send a string in the correct format, but as soon as I incl...

Dev_Local · Dec 06, 2019

I changed a column in Airtable from text to a checkbox (I am filling in with TRUE/FALSE (all caps)). Now I get this when I try to insert: data: { error: { type: 'INVALID_VALUE_FOR_COLUMN', message: 'Field "Active" cannot accept the ...

Dev_Local · Mar 05, 2020

Thank you, I tried once before sending the raw data from the DB which is stored as ISO 8601, and this failed. I will give this another try. I am using Postgres, the table definition is : not null default now which stores as UTC ISO 8601, selecting...

Dev_Local · Mar 05, 2020

It’s showing the previous day, not the next day. The time my process ran was: 3/5/2020 9:00 AM MT The time put into the database (programatically - UTC) was +7 seven hours later: 3/5/2020 :400 PM UTC. that is fine, that is what I would expect. No...

Dev_Local · Dec 10, 2019

Thank you, I did try to be as thorough as possible in my original question/post. Your initial comments were helpful and led to the solution, it put the thought in my mind to look at all possible things that could be wrong instead of focusing on typec...

Dev_Local · Dec 09, 2019

Before I changed the column to a checkbox, I was passing “TRUE” or “FALSE” all upper case with quotes, and then began to play with typecast, never got anything to work. After much experimenting, I got this to work by doing three things: 1. remove typ...

Dev_Local · Dec 09, 2019

I tried this again, looking at the placement of everything, and did find one correction that I made to reflect what I posted above. I am still getting failures, but this time something different. I sent the JSON through a JSON validator, and it all ...

User Statistics

User Activity

What is the correct way to use the API to send timestamps?

How to get linked record data using the REST API?

How to use REST API to delete up to ten records at a time using Node.js library axios?

Date fields and REST API

Where to add: "typecast": true (when column type is checkbox)?

Re: What is the correct way to use the API to send timestamps?

Re: What is the correct way to use the API to send timestamps?

Re: Where to add: "typecast": true (when column type is checkbox)?

Re: Where to add: "typecast": true (when column type is checkbox)?

Re: Where to add: "typecast": true (when column type is checkbox)?