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”...
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 ...
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 ...
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...
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 ...
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...
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...
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...
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...
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 ...
