Powershell command execute Snap
While trying to connect to Azure MySql Database we are getting the following error: Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host port...
Forum Discussion
Which Snap Pack are you using to connect to it? You’d need to use a MySQL Driver rather than Azure Sql (Azure SQL is a different database engine)
you should use the function mapKeys in a mapper snap to get the key value and rename it.
Inside the mapper snap you should use this expression:
$[‘soapenv:Envelope’][‘soapenv:Body’][‘ns1:MT_SWE_FI_PEGA_ABAON’].mapKeys((value, key) => key == “CLIENT” ? “CLIENTID” : key)This expression will first check every key if it equals the value “CLIENT” and if true it will rename it to whatever you want to rename it to. If false the key name is not changed
And give as target path the path of the original one until the object that contains CLIENT
$[‘soapenv:Envelope’][‘soapenv:Body’][‘ns1:MT_SWE_FI_PEGA_ABAON’]The result:
Regards
Jens
Thanks Jens. It worked
