Substring a field inside of an array?
I’m trying to substring the field $studySiteChecklist.checklist.lastUpdateDate but I can get it to keep the same output as the input.
Any ideas?
[{
"country": "a",
"studySiteChecklist": {
"c...
Forum Discussion
Hello Kiran, Could you share the output of the XML formatter as well as a screenshot of the mapper? Most likely, you’d need to use the JSON Splitter snap after to ‘flatten’ the data to fit into a relational database. Thanks!
The Authorization header is not accessible from a pipeline. Is it possible to also pass the value of the header in the request body?
That means we can not fetch header values in SnapLogic Pipeline.
I have to pass the Basic Authorization value i.e “Basic XXXXXXXX”.So only way is to pass through request body. Will you suggest some other options.
Please provide your inputs.
You can access certain headers from the request, for example:
- CONTENT_TYPE
- HTTP_ACCEPT
- HTTP_ACCEPT_ENCODING
- HTTP_DATE
- HTTP_USER_AGENT
- HTTP_REFERER
But not authorization.
If you’re not able to pass through the request body, I’m not sure there are a whole lot of other options.
The only other way I can think to do this is if there are a finite number of users. Then you could preconfigure REST Basic Auth accounts for those users and pass the account name as part of the request. Then in the pipeline you could dynamically set the account depending on the account name passed in.
I just wanted to ask a clarifying question. It sounds like you’re wanting to get the Authorization header that is passed to a triggered task, is that right? What API are you going to be calling in the pipeline that would use the SnapLogic user credentials?
Yes, your are correct. Below is the API call:-
/api/1/rest/public/users/UserName
