Filter/Ignore not null values
Hello,
I am trying to build a pipeline where a series of format operations must be applied to a CSV file. For some columns, I want to delete/remove or simply ignore empty rows from the file. I trie...
Forum Discussion
Unfortunately, the JSON Splitter snap does not expose the fully resolved path to the element being output. I’ve filed a feature request to add this functionality. In the meantime, you’ll need to use a Mapper with an expression to add the parent key name into the child object. For instance, the following expression will transform the input document to add a “parent” property to all objects with the name of the parent:
$.mapValues((v, k) => v instanceof Object ? v.extend({parent: k}) : v)Since you’re transforming the whole input document, you’ll want to use $ as the output document.
Then, in the JSON Splitter, you can use the ‘Include scalar parents’ option to have the ‘parent’ property added into the output documents.
Hi maheswara ,
The issue might be the JDBC Driver. From the screenshot you shared, I am not sure if you have configured the JDBC JARs Driver, but if you didn't, you need to download it and upload it in SnapLogic and then under the JDBC JARs configuration, upload/select the .jar file of the driver. You can download the latest driver or any version you need.
You can download it from the official docs: https://jdbc.postgresql.org/download/
Thank You j_angelevski , its working now.
Hi j_angelevski,
The above solution what you have given is working fine, but some time i am getting fatal error. Not able to connect that PostgreSQL.
Hi maheswara ,
Could you please provide more details about the error? It's a bit vague and could refer to various issues. Would you mind sharing the specific error message for clarification?
