topic null input to create a record in Dynamics 365 in Workato Pros Discussion Board

null input to create a record in Dynamics 365

croxxeyed — Sat, 05 Oct 2024 00:40:33 GMT

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!

Re: null input to create a record in Dynamics 365

mppowe — Sat, 05 Oct 2024 12:28:07 GMT

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

Re: null input to create a record in Dynamics 365

croxxeyed — Sat, 05 Oct 2024 22:46:51 GMT

Hi @mppowe

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