cancel
Showing results for 
Search instead for 
Did you mean: 

null input to create a record in Dynamics 365

croxxeyed
Deputy Chef I
Deputy Chef I

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!

2 REPLIES 2

mppowe
Executive Chef I
Executive Chef I

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

croxxeyed
Deputy Chef I
Deputy Chef I

Hi @mppowe 

I tried your suggestion, it continues to return error 'Currency (transactioncurrencyid)' must be present or Unsupported data type in the action input.