SnapLogic - Integration Nation

anayak · 09-02-2021

Hello, We get a client’s data each week and we try to encrypt the data using encrypt snap and Keystore account. Next, for decryption, we save the encrypted fields for each file into a separate file and append the encrypted new weekly data to the hist...

anayak · 09-02-2021

How can I load JSONB data using Postgres snaps? I’m able to load the data as TEXT type but not as JSONB type. Below is how I’m setting up my pipeline for inserting data to postgres db: Any answers would be appreciated!

anayak · 08-27-2021

Continuing the discussion from CSV Parser, no headers, hundreds of columns: I edited/added the Column Names to CSVParser snap for snaplogic pipeline and when uploaded it as a new file, all of them were empty however those number of fields were added ...

anayak · 08-27-2021

The title says it all, I want to add columns (around 600) and their start and end position automatically using a SnapLogic trick or Script. It’d be great if I could check the box for ‘Trim Column Data’ as well. Below is the pic for snap details: Man...

anayak · 08-19-2021

The header is a JSON file and content comes in a binary file as can be seen from the trigger task debug trace below: Tried using the pipeline below and I only get the response header also included below and can’t find a way to get the content:

anayak · 09-07-2021

Never mind, was able to resolve by casting to jsonb using the execute snap. Thanks!

anayak · 09-07-2021

@Supratim thanks for your response. We don’t want to encrypt entire documents rather just some columns and I think binary encryption snaps don’t do what we need as they encrypt all the columns at once. Please let me know if there are other ways to so...

anayak · 09-07-2021

@pmanchevski When I use Bulk Load, the auto-increment process_id column can’t be left empty but it does allow loading jsonb data. If I use Insert snap, then JSON.stringify() does make a json string but Inser Snap reads it implicitly as varchar/text a...

anayak · 09-06-2021

I have tried JSON.stringify and Json.parse, the value is converted to JSON but not read as jsonb when run with Postgres-Insert snap. Will try bulk load and execute snaps instead. Thanks!

anayak · 08-31-2021

@alchemiz @dwhansen-cbg When I tried editing json and adding column field values for csv parser, all the column fields went empty when I re-uploaded the file into csv parser. do you know what might be happening. here’s a post Editing JSON for CSVPars...

SnapLogic - Integration Nation

User Statistics

Re: Loading jsonb postgres data

Re: How to Decrypt fields for an entire table at o...

Re: Loading jsonb postgres data

Re: Loading jsonb postgres data

How to Decrypt fields for an entire table at once?

User Activity

How to Decrypt fields for an entire table at once?

Loading jsonb postgres data

Editing JSON for CSVParser to add hundreds of headers

FixedWidthParser Snap, automated loading of columns from csv instead of manually adding 600 columns

Getting The Response Header and not Response Content from Jira Webhook

Re: Loading jsonb postgres data

Re: How to Decrypt fields for an entire table at once?

Re: Loading jsonb postgres data

Re: Loading jsonb postgres data

Re: CSV Parser, no headers, hundreds of columns