topic Re: Generate a user specific SMSESSION cookie calling a WebService in QlikView

Generate a user specific SMSESSION cookie calling a WebService

dmohanty — Tue, 25 Apr 2017 16:02:12 GMT

Hi Team,

From QlikView, wanted to call a Web Service that would pass on the User ID dynamically and generate a SMSESSION every time.

Need to pass a URL like this below that needs a Header and API Key.

Generate JWT HTTP Request:

GET https://iri1lvu09j.execute-api.us-east-1.amazonaws.com/oe_stage/api/v1/token-generator/generate?user=user’s login id

Headers

sm-session: User’s SM Session token

x-api-key: Qlik API Key

Went through other links Web Service calling to generate XML -

How to read Amazon S3 files - approach #1 - Web File

https://community.qlik.com/docs/DOC-18234#comment-59472

Call a web service via SOAP, HTTP Get or HTTP Post

Using the above links, similarly wanted to proceed with some solution. Any possible help/ideas please?

Regards!

Re: Generate a user specific SMSESSION cookie calling a WebService

dmohanty — Mon, 01 May 2017 19:24:02 GMT

Hi All,

To simplify more -

Fetch the SMSESSION cookie from the login browser (may be using a Macro). Store in variable or notepad.
Use this SMSESSION as one of the header input and X-API-KEY as another input to call the URL (HTTP Request)

GET https://iri1lvu09j.execute-api.us-east-1.amazonaws.com/oe_stage/api/v1/token-generator/generate?user=user’s login id

Create the Cart by calling the URL –

POST https://dzrsa753r1.execute-api.us-east-1.amazonaws.com/oe_stage/pd/ecom/v1/carts

Here are the inputs –

Authorization – JWT Token

X-API-KEY - Qlik API Key

Content-Type: application/json

User – User’s Log in id

UUID - cb6d61da-1eb4-4827-bc32-fb2a71f15f8b (It is just a unique transaction tracking identifier. We can use whatever you want to generate it and can be any format. It will be part of the API logs we can find it in Splunk. It should be unique per request. It will accept the same one on multiple calls and does not do duplicate checking.)

Re: Generate a user specific SMSESSION cookie calling a WebService

BalaBhaskar_Qlik — Sun, 19 Aug 2018 12:09:45 GMT

Did you cleared the issue, post the solution.