Right now, I receive First and Last name in an Integration in the following formats: All UPPERCASEAll lowercaseCorrectly Formatted NamesI use the .titleize function to correct the first 2 cases and it works a charm. For case 3, 90% of the time it wor...
Hi all, My process is that I have a list of data, I extract the relevant data from the list, add the data to the payload, and then POST that data to a particular endpoint. The key consideration is that when a key-value pair has a null value, that key...
Hey all - I need to compose a CSV in Workato that I am not sure is possible, here is my criteria (screenshot below): Row 1 has to be as follows: EmployeeManagerImport,,,,,,Row 2 has to be as follows: H,EmployeeManager,EmployeeManager,EmployeeXRefCod...
I actually think I solved my own issue.... I used ruby in the formula if input.match?(/\A[A-Z\s\-']+\z/) || input.match?(/\A[a-z\s\-']+\z/)
input.titleize
else
input
end Curious if anyone else has another solution though!
@shivakumara @Prudvi @gary1 If you are interested in a no-code solution to omitting nested null key-value pairs from a JSON payload, please add signal to the below ideas: https://ideas.workato.com/app/#/case/415544?cpid=931134c4-fa0c-41ba-815c-c31e90...
This is great - the method worked a charm. The key here is that the Ruby method allows a recursive search through an array. Since I was dealing with multiple hashes & arrays, the Deep_Compact Ruby method worked perfectly. If I were working with a mor...
@csadler Unfortunately I have not observed the behavior you are proposing. When I have used the [skip] function, I have observed the exact same thing as @sampath . The key-value pair shows up in my payload as having a "null" value. I also need the k...
