cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Passing credentials in JSON body to authorization endpoint

jervin
New Contributor III

Some services I am working with require a REST Post to an authorization endpoint obtain a session token to be used in the header in subsequent REST calls. The authorization endpoint requires the account credentials to be passed in a JSON object in the request body.

This can be accomplished easily enough in SnapLogic by using a JSON Generator and a REST Post Snap.

2020-10-02 13_51_36-SnapLogic Designer - Export Informatica Activity Log - _TWUDev_projects_Jacob Er

2020-10-02 13_52_14-SnapLogic Designer - Export Informatica Activity Log - _TWUDev_projects_Jacob Er

However, this is not ideal from a security or account management perspective because the account credentials are stored directly in the pipeline in plain text and not as an account object.

Is there a better way to store credentials and use them in a pipeline for services that use this kind of authentication pattern?

1 ACCEPTED SOLUTION

@jervin @Spiro_Taleski @kamalaker.pinna Actually this is possible but this is somewhat of an undocumented feature that does not have finished integration with our UI - however I will describe how this can be done with the REST Snap Packโ€™s Basic Auth and OAuth accounts.

The REST Snaps (POST/GET etc) are able to reference the account configured on the Snap through a special account variable, account.

This is different that how standard variables are referenced; per-document variables that come from an input document have the "$" prefix (e.g. $someField, whose value can be different for each input document to the Snap) and pipeline variables, called Pipeline Parameters, that are static for the pipeline execution lifecycle and denoted with the underscore prefix (e.g. _someParameter).

However, if a field is expression-enabled and uses a value of account in the REST Snap Pack, a reference to the account (if compatible) can make some fields from that account accessible to the Snap configuration.

Unfortunately our UI integration here is incomplete here for Basic Auth and it will generate a UI error, but the account data binding will actually work correctly.

So for a Basic Auth account, you could do the following:

image

The account.username and account.password account variables will bound to their respective values and then sent as part of the HTTP request body.

For OAuth 2.0 accounts, the only account variable field available is account.access_token (which is mentioned on the documentation) - this gives access to the OAuth access token.

It may be possible to use this technique to simplify and secure your solution, but it does have some downsides in terms of our product interface experience plus the complications that can arise when the Snap attempts to use the account credentials in the way it expects in addition to the customizations made to the request by the user.

Perhaps you can try this out and let me know your feedback please.

View solution in original post

12 REPLIES 12

SpiroTaleski
Valued Contributor

Hi @jervin

You can try with REST Basic Auth Account.

In the REST Post snap(Account Tab) you should select the created auth account:

image

Regards,
Spiro Taleski

kamalaker_pinna
New Contributor

Hi,

@Spiro_Taleski , @jervin

I have the similar request. Need your help in how to refer the SnapLogic Account in Rest POST API call. As of now we are passing via Pipeline properties. I want to substitute the credentials from Rest Basic Auth Account.

Community Post:

Current Pipeline Setting:

image

image

@jervin @Spiro_Taleski @kamalaker.pinna Actually this is possible but this is somewhat of an undocumented feature that does not have finished integration with our UI - however I will describe how this can be done with the REST Snap Packโ€™s Basic Auth and OAuth accounts.

The REST Snaps (POST/GET etc) are able to reference the account configured on the Snap through a special account variable, account.

This is different that how standard variables are referenced; per-document variables that come from an input document have the "$" prefix (e.g. $someField, whose value can be different for each input document to the Snap) and pipeline variables, called Pipeline Parameters, that are static for the pipeline execution lifecycle and denoted with the underscore prefix (e.g. _someParameter).

However, if a field is expression-enabled and uses a value of account in the REST Snap Pack, a reference to the account (if compatible) can make some fields from that account accessible to the Snap configuration.

Unfortunately our UI integration here is incomplete here for Basic Auth and it will generate a UI error, but the account data binding will actually work correctly.

So for a Basic Auth account, you could do the following:

image

The account.username and account.password account variables will bound to their respective values and then sent as part of the HTTP request body.

For OAuth 2.0 accounts, the only account variable field available is account.access_token (which is mentioned on the documentation) - this gives access to the OAuth access token.

It may be possible to use this technique to simplify and secure your solution, but it does have some downsides in terms of our product interface experience plus the complications that can arise when the Snap attempts to use the account credentials in the way it expects in addition to the customizations made to the request by the user.

Perhaps you can try this out and let me know your feedback please.

kamalaker_pinna
New Contributor

@robin,

Thanks a lot for making me understand in detail of different approaches.
I tried account.username & account.passowrd in my API call but it errored out with below

โ€œerror_entityโ€:
โ€œ{\r\n โ€œerrorCodeโ€: โ€œAUTHORIZATION_INVALID_TOKENโ€,\r\n โ€œmessageโ€: โ€œThe access token provided is expired, revoked or malformed.โ€\r\n}โ€

Below snapshot is how my API call looks like.

image

The same API call works fine when i pass through pipeline properties like below

โ€˜{โ€œUsernameโ€:"โ€™+_SecretName+โ€˜โ€œ,โ€œPasswordโ€:โ€โ€™+_SecretText+โ€˜",โ€œIntegratorKeyโ€: "โ€™+_SenderIntegratorKey+โ€˜"}โ€™

Please let me know if I am doing anything wrong here.

Thanks,
kamal