Hey, I’m trying to map the result of a VAT check (Vies API) to a database. There is some unexpected behaviour: Although the value comes as “false”, the Boolean fiels is always set to “true”.
I’ve added the value to a text field, and it states the “false” values correctly. What am I doing wrong?
Mapping:
Output from the previous field (Vies API VAT check):
How it is handled:
The “Message” field shows the correct “false” value. But the VAT Check Approved boolean field shows a “true”. 
Welcome to the Make community!
You didn’t provide a full screenshot of the output bundle.
Please provide the output bundles of the module [5] by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading them here will look like this:
module-1-output-bundle.txt (12.3 KB)
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:
Either add three backticks ``` before and after the code, like this:
```
input/output bundle content goes here
```
Or use the format code button in the editor:
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
This will allow others to better assist you. Thanks!
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
Here’s the requested files:
module-5-vat-output.txt (855 Bytes)
datastore-input.txt (674 Bytes)
As I suspected, there are two arrays.
You can either click on this
or do this
For more information, see “Mapping with arrays” below:
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
parseDate | Tokens for formatDatesamliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
Thanks for your suggestion. Unfortunatelly, this did not lead to a solution yet. I tried the “clicking on [1]” part already before, and it did not lead to a solution, sorry for not mentioning it. I also now did a test with the first(map()) solution – also, not successfull.
All three of them lead to the right value (false) in a text field, none of them leads to the Boolean field being set to false.
New test Output:
module-5-vat-new-output.txt (855 Bytes)
New mapping, input and result:
Any additional ideas?
Okay, I think I got it – there seems to be a difference between the Vies VAT true/false and a boolean true/false.
This if condition fixed it:
