Forum Discussion
Hi @swright,
You need to concatenate the jsonPath with the pipeline parameter.
jsonPath($, "$entity.items[?(value.AssignmentNumber=='" + _AssignmentNumber + "')].links[*]").find(x=>x.name == "assignedPayrolls").href
Thank you! Your solution worked perfectly! I had tried something like that before and it failed. It was probably my syntax but your syntax worked on the first try!
- bojanvelevski4 years agoValued Contributor
Hey @eshanbhatt,
I’ve also had some issues with JDBC snaps in the past, especially with the Select. As I remember my error was related to the tables, and switching to Execute snap with query, fixed the problem. You can give it a try.
I hope this helps,
Bojan- eshanbhatt4 years agoNew Contributor
Hi @bojanvelenski,
Thanks for the quick response.
I’ve tried the same steps with all JDBC snaps. My issue is within the Account Setup, where I’ve tried with different postgresql jars but the account validation itself is failing.
The error is also not clear if there is an issue with my server or driver or some issue with snapLogic.