nluu
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Get Bearer token via OAuth1 in SnapLogic
Hi all, currently, we are trying to build a pipeline that communicate with another API through REST. For authentication, we need to get the Bearer token through calling POST request to: {endpoint}/token, using Authorization OAuth1.0. On postman, the setup will be as follow: In the Authorization tab, the Signature_Method is set as “HMAC-SHA256”, then client_id and client_secret is provided. The “Encode the parameters in the Authorization header” box is also select. I don’t know how can we setup the same in SnapLogic, as I used Digest.sha256() seems not the correct way to create signature with “HMAC-SHA256”. Besides, I tried with creating REST OAuth1 and OAuth2 account, but both needs authorization endpoint etc, and not serving our scenario. Does anyone know if it is possible to perform the same action in SnapLogic? Thank you in advanced. Best regardsRe: JSOn body for property with null value
bojanvelevski: $input.mapKeys((v,k)=> “my_”+k.toLowerCase()) Hi @bojanvelevski, thank you for your response. It actually a very good solution. But in my case, the name is not always in the format of “my_” + key. The name will depends on the naming I agreed with the Database team and the CRM team, so sometime it will be like “close_date”: $input.ProductEffectiveDate_c etc. But I’ll try to base on your suggestion to find out the solution. Thank you so much Regards2.6KViews1like1CommentJSOn body for property with null value
Hi all, I’m having an issue while designing the mapping property with null value for my JSON object. For example I have a Mapper to map $input to $body with the expression like follow: {“my_id”: $input.Id, “my_name”: $input.Name, “my_address”: $input.Address }. When the $input is {“Id”: 123,“Name”: null, “Address”: “A Street, B District, C City”}, the $body should be: {“my_id”: 123, “my_name”: null, “my_address”: “A Street, B District, C City” }. But when the $input is {“Id”: 123, “Address”: “A Street, B District, C City”}, the $body should be: {“my_id”: $input.Id, “my_address”: $input.Address }. I tried with hasOwnProperty() and hasPath(), but they all treats the null value as not existing property, so it will not work. Does anyone know how can I keep the null value for mapping, but eliminate property that does not exist in the $input. Thank you in advanced. best regards.2.9KViews0likes3CommentsBulk Load data into Postgresdb
Hi all, currently we have a JSON with thousands of objects as following: {[ {id:1, Name: a}, {id:2, Name:b}, {id:3, Name:c}… ]} We tried to use the PostgreSQL - Bulk Load, snap to load data into our database. I would like to ask that do we need to do any transformation before, or only the JSON Splitter is engouh? Besides, if the “id” value, which is a unique constraint already existed, how to skip the insertion? Thank you in advanced.1.2KViews0likes0CommentsRe: Posting xml to webservice through rest post snap
hi @yashasvi74, Could you please provide the body of the request, and the error that you got? Did you already try to build the body of the request in the form of XML as a String? The body must include all namespaces like env:…. I worked for me in my case. Regards, Trung.2.8KViews0likes2Comments