pmanchevski
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Loading jsonb postgres data
Hi @anayak If you are able to load it as TEXT easiest fix would be in the mapper to use JSON.stringify(value) function. This function will convert your value into JSON string. Also you can try to insert your records with “PostgreSQL - Bulk Load” or with “PostgreSQL - Execute” snaps. Regards, Pero Manchevski4KViews0likes3CommentsRe: Executing different SOAP request's based on input field value
Hello @arunnp The provided JSON in the ExecuteApplicationResult field it’s not valid json. The main issue is the double quotes after string “Windows” You can try to remove it with regex, but that won’t guarantee that this will be working solution in the future. Try to map it ExecuteApplicationResult to result and pass it like that. Regards, Pero Manchevski2.6KViews2likes0Comments