performUpsert using field of type decimal does not works correctly, when number is integer

Topic Labels: Automations
572 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I want to do upsert using field of type decimal as matching field, but it does not work if number is whole integer, like 12 or 12.0. Item was not updated and instead was inserted new one


I know it is possible to use some hack, sending number as a string with exact precision and using option typecast: true, but it would not fit my automation task



2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

I haven't tested this, but the documentation for `performUpsert` seems to indicate it only works on 1 record, but it looks like you have 2 records with a value of `12.0` — documentation snippet below:



That's correct, and if it would work correctly it should find 2 records and throw an error, but instead a new record inserted