Issue with API and boolean fields

I am using an API for a site which I sync against once a day

The API returns a number of nested objects.

Here is the schema

To process the API i simply repeat through the various nested objects and push those values into tables

I have recently experienced a problem with those returning Boolean values

The “properties” object is the parent object and amongst other things returns a boolean value “rooms_let_individually” as below

image

So at a basic level i pull all the properties details from the API which returns multiple property objects and then use a repeat to step through the records and insert the data into a table

If i miss out the items which have a boolean value all works correctly and the records are inserted

however if I add the field “rooms_let_individually” as below

The server actions runs, the API returns the data, no error is displayed on screen or in the developers console however no records are inserted into the database.

I have recreated the SA from scratch, reinstalled Wappler with a clean install.
I am using the inbuild table manager and have tried setting the field to Boolean, int and string in case it is a data type mismatch issue.

Assuming this is not a new bug, I am running out of ideas, anyone help?

I have been doing some work relating to this API in the past and have not seen this issue before

Community Page
Last updated: