I need to produce an HTML email that includes both pipeline variable information in the HTML header and an HTML table that is a multiline error report. I can make one or the other work, but not both. The error report is being read from a database t...
Hi Team, I'm pulling data from the source system which have "n" columns, I wanted to count the number of columns that I'm getting from the Source System. So that to map them with the respective Target System. Please help me out this, Thanks in advanc...
Hi All,I want to convert an input array to expected array. Can you please suggest. Input Array :"Customfield": [{"fieldname": "RECTY","fieldvalue": "S01"},{"fieldname": "LFDNR","fieldvalue": "0000004"},{"fieldname": "ARE4","fieldvalue": "467Q"}]Expec...
Hi team, There are few fields where I'm having value as NULL, I want to make NULL in to blank, in all the Fields where I have the NULL. Help me in a way so that I can write a logic which can replace all the NULL in to Blank.Thanks in Advance.
Convert this accountIdregionreporttypecount1APACL1 Feedback Report21APACL2 Feedback Report22APACL1 Feedback Report62APACL2 Feedback Report43APACL1 Feedback Report173APACL2 Feedback Report43EUL3 Feedback Report3 to below one accountIdRegionL1 Feedba...
I'm having an issue with the XML Generator. I feel what I'm doing should work. Hoping someone can enlighten me on what's going on. I have an array that gets passed into the XML Generator snap. For each instance within the input array, I am attempting...
I've setup a MySQL server on AWS RDS and I am able to connect to it from MySQL Workbench and setup a database and table with data. I am trying to connect to the account from SnapLogic below using the MySQL Database Account and am receiving errors bel...
I've setup a MySQL server on AWS RDS and am able to connect to it from MySQL Workbench and setup a database and table with data. I am trying to connect to the account from SnapLogic below using the MySQL Database Account and am receiving errors below...
