Hi memrbers,The Workato connector for Oracle SQL is converting whitespace to NULL values when inserting, updating, or upserting data into a table.Specifically, this column (e_mail_address, char (60) ) is defined as NOT NULL in the table schema, and i...
when building a custom action, Is there a way to access the calling recipe properties*** ?something like this would be great, but *_dp* does not compile:_dp('{"pill_type":"job_context","path":["master_job_id"]}')*** specifically, the properties that ...
it seems like a simple upsert into the OrderItem or products object in sfdc but get the error message that doesn;t really give me a clue as to what might be wrong 28 Status code: JSON_PARSER_ERROR,29 Message: Cannot deserialize ins...
I am looking at creating a recipe that will synch up our ERP orders from Epicor into the Order object in SFDC.this will help with reporting on forecasting and backlog etcwhat's the best practice here I can easily check to see if the Order exists in S...
Hey all,I have used the Python action to output a list, I've provided the schema and I can iterate over it without issue. However, what I would like to do is filter the list before iterating over it. So for example, the list contains an ID field, I c...
Hello everyone! hope you guys can help My concern is unrelated to Workato development. I took the Automation Pro II exam and failed twice and I'm wondering if there's a way to retake that or if you can point me to the right direction, I'd really app...
How do you make an existing recipe use an updated connector other than deleting the connection and re-adding it?
after POs are booked and my recipe sends emails out to Sales and OMs to let them know what happened the prices are hard to read since there is no formatting.for example they see:Op Amount: $3891266.55 (USD)they would like to see:Op Amount: $3,891,266...
I need to extract and store the File Path and Filename.EXT from a string into 2 variables.example: \\Server\folder\folder\filename.extI want to end up with:Variable1 = "\\Server\folder\folder\"Variable2 = filename.extIs regex the best way to accompl...
I need to connect to clients SFTP which goes something like SFTP-Cloud have shared a file with me which i am guessing is a public key gies something like sftp-cloud ssh-rsa AADDDBBBBB..... so on. How do i connect to their SFTP?how to ass their public...
