The Deals API returns the ‘amount’ field as a string, even though the documentation states it should be a number. Additionally, when the value is missing, the API returns an empty string (“”) instead of NULL.
Same with date fields
Is this expected behavior? Why would you do that?
This has been discussed many times. It is expected.
do I like it ? No. Amount as a string is because of different currencies and the way amounts are written. I believe it should just be 1200 for 12.00 or 12,00 and the property should be related to currency as the display instead of storage.
This is one of the items that causes pain for people from other systems.
Thank you for your quick response.
I am using Azure Data factory and especially the “” -values are causing problems in the mapping to a sql-server table.
I guess I need to change the data type to varchar and convert it in de db.
I’m not familiar with the azure data factory -- but in JavaScript I typically loop through all of my properties and remove any empty or null items before moving the data elsewhere.