Expression Library - navigating JSON arrays
I would like to create an expression library that traverses a JSON array, but I am unsure of the syntax as it does not seem to match what I usually use in a pipeline (JSONPath). Say I have "LateralS...
Forum Discussion
Hi @Siva_Venna,
I think that would work. It seems like there’s a bug in the SQL snap’s expression evaluation where it’s choking on Date.now(), but if you already have the $year field I would think you can use ‘abc_’ + $year to get the tablename. Give it a try!
- Judy
I gave a try it did not work. Hope the fix will resolve the issue.
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)
We’ve changed the type of the account to MySQL Database Account. After that we’ve managed to connect to the MySQL Azure database.
