Data API not recognizing date

Need help APIs
1

I’m trying to import a large number of records using my project’s Data API. I have a date field called “Date (timestamp)” for each record to import. I’m using a workflow to get 100 records at a time from another API as an action, then I’m using Bubble’s Data API to import those records. For some reason that I can’t understand, the Data API throws this error (copy-pasted from my logs until the …):

Workflow error - The service Bulk Data - Insert Downloads just returned an error (HTTP 400). Please consult their documentation to ensure your call is setup properly. Raw error: {"status":"error","message":"Invalid data for field Date (timestamp): Expected a date, but got a string (original data: \"Jul 14, 2023 5:41 pm, Jul 14, 2023 7:06 pm, Jul 14, 2023 7:27 pm, Jul 17, 2023 1:51 pm, Jul 17, 2023 2:28 pm, ...

The “original data” all looks just like the first item, “Jul 14, 2023 5:41 pm”

What’s weird is when I use Postman to look at the same data I retrieve from this other API, the date fields are in ISO format (2023-07-14T23:41:52.362Z, etc.)

Can anyone see why this is breaking?

2

U have to do the date then :formatted as → Simplified extended ISO
The date should be in ISO format for Bubble to understand, not the nice looking display date they use like “Jul 14, 2023 7:27 pm”

3

That seems like it should have worked but I got essentially the same error:

Workflow error - The service Bulk Data - Insert Downloads just returned an error (HTTP 400). Please consult their documentation to ensure your call is setup properly. Raw error: {"status":"error","message":"Invalid data for field Date (timestamp): Expected a date, but got a string (original data: \"2023-07-14T23:41:52.362Z, 2023-07-15T01:06:15.237Z,...