How to use security token

Topics: Example / Documentation
Jun 19, 2016 at 5:47 PM
hi

i try to get data from secure server, for acces JSON Api, i receive an Authorisation token.

but i don't find where a have to configure this string.

Some one can help me ?

if it's possible and how i can do.

sample :
Authorization: application=eb1b5a84-xxx-xxx--xxxxx-XXXXXXX

Best regards
Coordinator
Jun 19, 2016 at 9:17 PM
Hi,

I don't understand what you mean. Would you please give more details about your problem? Sometimes authorization tokens have to be put directly as GET parameter. In that case you might use the HTTP Parameter section of the JsonSource component. Also, from your post I don't understand whether the token has to be a HTTP Header or a HTTP parameter.

Alberto.
Jun 20, 2016 at 10:16 AM

HI

Sorry for this quick question without context,

First, thanks for this answer, my context is to get Json data form SAAS application (timesheet), our provider get us documentation and token :

Extract from his documentation page : http://developers.lucca.fr/fr/API/authentication

And I search to use it directly in our SSIS server with your component.

Documentation just ask us to add “Authorization” token, I think it’s done in HTTP Header.

GET https://sandbox.ilucca-demo.net/api/v3/users

Authorization: Lucca application=eb1b5a84-dc51-417c-bf79-abcfc97b40e2

Is it possible?

Thanks.

De : webking [email removed]
Envoyé : dimanche 19 juin 2016 23:17
À : [email removed]
Objet : Re: How to use security token [jsonsource:655706]

From: webking

Hi,

I don't understand what you mean. Would you please give more details about your problem? Sometimes authorization tokens have to be put directly as GET parameter. In that case you might use the HTTP Parameter section of the JsonSource component. Also, from your post I don't understand whether the token has to be a HTTP Header or a HTTP parameter.

Alberto.

Coordinator
Jun 20, 2016 at 11:25 AM
Hi,

from the documentation I read that the token has to be transmitted via HTTP Request Header. This feature has not been implemented yet, I am sorry. It may be implemented on the next release of the software, which should take place by the end of August.
I am opening a workitem for this issue, since it is part of a major task, partly already implemented.
Coordinator
Jun 20, 2016 at 11:27 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Nov 6, 2016 at 11:41 PM
Hi!

The latest version of the component supports HTTP Headers, including authentication. Give it a try!
Nov 18, 2016 at 6:19 AM

Hi

Fine, i’ll test it asap.

Best Regards

De : webking [email removed]
Envoyé : jeudi 17 novembre 2016 23:56
À : [email removed]
Objet : Re: How to use security token [jsonsource:655706]

From: webking

Hi!

The latest version of the component supports HTTP Headers, including authentication. Give it a try!

Nov 18, 2016 at 12:07 PM
Edited Nov 21, 2016 at 12:13 PM
Hi I test your evolution this morning, it’s works but not in all case, I try to explain: For basic testing, I put my security value in new box “ HTTP Headers”, it’s work fine (but how I can remove a line ?) I test with : https://XXXXX.XXX.XXX/api/V3/leaveusers and it’s work fine with security header. But when I have a “complex” request like : https://XXXXX.XXX.XXX/api/V3/leaveusers?fields=id,lastname,firstname,name,displayname,mail,dtcontractstart,dtcontractend,employeenumber,cspid,senioritydate,birthdate,departmentid,department.id,department.name,managerid,manager.id,manager.name,legalentityid,legalentity.id,legalentity.name&id=greaterthan,0 I put this request, I receive an distant error, when I make a capture of https request I can trap this request with fiddler : This I wat your solution send over network : https://XXXXX.XXX.XXX/api/V3/leaveusers?fields=id,lastname,firstname,name,displayname,mail,dtcontractstart,dtcontractend,employeenumber,cspid,senioritydate,birthdate,departmentid,department.id,department.name,managerid,manager.id,manager.name,legalentityid,legalentity.id,legalentity.name&id=greaterthan,0& with a strange “&” at the end, and request fail on distant side. I hope this help you to continue improve your solution. Best regards De : webking [email removed] Envoyé : jeudi 17 novembre 2016 23:56 À : [email removed] Objet : Re: How to use security token [jsonsource:655706] From: webking Hi! The latest version of the component supports HTTP Headers, including authentication. Give it a try!
Coordinator
Nov 24, 2016 at 2:48 PM
Hi,

I've just updated a new version of the DLL Pack which should solve that issue.
Also, I've added a DELETE button to remove the entries in the HTTP Parameter and HTTP Headers guis, although you could use the "CANC" button on the keyboard to remove a line.

Please reinstall the DLL pack and let me know if the problem is now solved.

Regards,
Alberto.
Marked as answer by webking on 11/24/2016 at 7:48 AM
Nov 25, 2016 at 3:24 PM
Hi,

i make a quick test, and it's seems OK, i continue testing later.

Notice my installation folder for your DLL is on my server "Microsoft SQL Server share\130\DTS\PipelineComponents"

Best regards
Nov 27, 2016 at 9:06 PM
Hi WebKing

My tests are good when i store data inside SQL database, but i found a problem where i use Excel output (when control try to get fields for create sheet, it close).

I fail to attach my VS2015 debugger with Var WK_DEBUG ...

Best regards