10-04-2024 05:40 PM
Hi, I am new to Workato. I was able to create a record with null input using Power Automate flow. The test input:
{
"object_name": "30b0cd7e-0081-42e1-9a48-688442277fae$opportunities",
"name": "TEST",
"transactioncurrencyid__reftransactioncurrency": null
}
But failed when trying to do the same with Workato. The test input:
{
"object_name": "30b0cd7e-0081-42e1-9a48-688442277fae$opportunities",
"name": "TEST",
"transactioncurrencyid__reftransactioncurrency": null
}
The error 'Currency (transactioncurrencyid)' must be present was returned. What should I pass null using Workato successfully? Thanks in advance!
10-05-2024 05:28 AM
Usually I find I have to use "skip" (in formula mode) so that null fields aren't included, rather they're omitted. I think DateTime fields may encounter the same issue. For example:
myCurrentVariable.presence or skip
a month ago
Hi @mppowe
I tried your suggestion, it continues to return error 'Currency (transactioncurrencyid)' must be present or Unsupported data type in the action input.