ContributionsMost RecentMost LikesSolutionsRe: Loading jsonb postgres data Never mind, was able to resolve by casting to jsonb using the execute snap. Thanks! Re: How to Decrypt fields for an entire table at once? @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 solve for what I want or how can I develop a custom snap if needed. Thanks! Re: Loading jsonb postgres data @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 and I have no way to typecast in the Insert Snap. Also, as the data is coming from an excel file where $(all of the excel file data) is used in a column in the table, I’m not sure how to load the data as JSONB using the execute or insert snap. Here’s the mapper fields: followed by Insert: Re: Loading jsonb postgres data 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! How to Decrypt fields for an entire table at once? 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 historical table. There’s a huge problem, when we have to decrypt. Since we have encrypted fields saved in a separate file for each weekly file, we can’t decrypt the entire historical table at once for that client. The goal is to have a way be able to decrypt the entire table as and when we need it. Here’s how it looks now: Loading jsonb postgres data 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! SolvedRe: CSV Parser, no headers, hundreds of columns @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 CSVParser to add hundreds of headers i have created for the same. thanks! Editing JSON for CSVParser to add hundreds of headers 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 in the snap. below is how I made chnages to the pipline by opening .slp file in a text editor: "columnList": { "value": [ { "column": { "value": " Number" } }, { "column": { "value": " Suffix" } }]} This only gives empty headers. Please suggest how could I make changes to JSON file also let me know if there are better ways to write Column Names without having to add them manually? Thanks! FixedWidthParser Snap, automated loading of columns from csv instead of manually adding 600 columns 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: Manual work seems a lot and can invite errors. We already have a well-formatted CSV with column names and their start and end position and I would be able to automate the process of adding columns to FixedWidthParser. Any help and ideas are appreciated! If it’s not possible then I’d appreciate ideas about how can I develop a solution myself. Re: Getting The Response Header and not Response Content from Jira Webhook @Supratim Also when I run the snap, I can’t get any intermediate results or only empty json is being returned every time? I can see the files in the debug trace and they look fine but when I check snap results, they are empty. Also, when using REST API(GET/POST) snaps, the intermediate results in the snaps are not there.