ContributionsMost RecentMost LikesSolutionsFilter out the specific column to filter out column A if it is null but not other columns [ { "Record" : [ { "Customfields": { "A" : "", "B" : "defg" }, "Name" : "khu" } ] } ] Replacing many special characters using one function one time Hi All, I want to replace the following special characters : > % ? \ with space . I do not want to use multiple replace function. Is it possible to do with one replace function. Thanks for your time. Replace value according to its poition Below is the Input [ { “@id”: “2”, “col”: [ { “@id”: “2”, “@transable”: “yes”, “$”: “Replace1” }, { “@id”: “3”, “@transable”: “no”, “$”: “Replace2” } ], “group”: [ { “A”: “A1”, “B”: “B1”, “C”: “C1”, “D”: “D1”, “E”: "E1 ", “F”: “F1”, “G”: “G1”, “H”: “”, “I”: “” }, { “A”: “A2”, “B”: “B2”, “C”: “C2”, “D”: “D2”, “E”: “”, “F”: “F2”, “G”: “G2”, “H”: “”, “I”: “” } ] } ] expected Output : [ { "group": [ { "A": "A1", "B": "B1", "C": "C1", "D": "D1", "E": "E1 ", "F": "F1", "G": "G1", "H": "", "I": "" }, { "A": "A2", "B": "Replace1", "C": "Replace2", "D": "D2", "E": "", "F": "F2", "G": "G2", "H": "", "I": "" } ] } ] explanantion : @id refers to row number of the group and @id under col refers to the column number of the group where replacement needs to be done with the value of "$" Re: SalesForce - REST API with OAUTH2 Token Auto Refresh Issue Hi, Could you please let us know what have you given in callback url at salesforce end. We are getting the below error while clicking on “authorize” in snaplogic salesforce oauth2 account. error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration REST API ERROR 503 error keeps on increasing even if input is one Hi All, I used a REST API with pagination where there was only one input but due to server unavailability , I got an 503 error. But my doubt is why the error was keep on increasing. Since the error was keep on increasing i had to stop the pipeline. Can anyone please help. Re: To access Mainframe Dataset Didnt work Re: To access Mainframe Dataset yes. URL → ftp://host/'TSSP.CUS.BFO.INBND.CUSTOMER' I copied and pasted same url in file* filereader snap but it doesnt give any output. Re: To access Mainframe Dataset Te dataset starts with single quote and ends with single quote. I tried with quotes , without quotes , and also the way u have given …but it is not showing any result. Re: To access Mainframe Dataset You mean to give the quotes the way you have given in first comment ? Re: To access Mainframe Dataset It didn’t work.Mainframe is is z/os