Forum Academy Marketplace Showcase Pricing Features

Possible to bring boolean data into the database from the API or must it be a text field?

Hi.

Is it possible to bring boolean data into the database from the API or must it be a text field? I ask because I’m getting an error when it’s specified as type = yes/no.

My boolean responses are: true/false

I have two endpoints that talk to one another to POST data and then return the results of the POST to my database. The 1st endpoint uses “Schedule API Workflow from a List” to POST data and collect the response. The 2nd endpoint receives the response from the first endpoint and puts it in my database.

I’ve configured fields in the 2nd endpoint to be type = yes/no. But, the Schedule API workflow from the 1st endpoint, doesn’t let me collect the POST response as boolean. It works just fine if the 2nd endpoint type = text.

When the 2nd endpoint wants yes/no, Schedule API Workflow (red field = boolean) throws this error:

When the 2nd endpoint wants text, Schedule API Workflow is happy as could be. (but the data is stored as the wrong type)

The only difference is whether the 2nd endpoint expects text or yes/no