Odata service credentials

  • 16Views
  • Last Post 2 weeks ago
0
votes
Marina Seredova posted this 2 weeks ago

How can we pass the the Skyvia connect credentials(user,password) that have been setup in the Odata service in requests?

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

Hello, Marina! Unfortunately, currently it is impossible to do. We will post here if any news regarding this sceanrio is available.

0
votes
Marina Seredova posted this 2 weeks ago

Then what is the point of having Users setup option in Skyvia connect for particular OData services? If we cannot pass them as parameters? I am confused.

0
votes
Mariia Zaharova posted this 2 weeks ago

Users section allows to create user and password credentials which will be allowed to access your endpoint. These credentials can be specified either in the pop-up window when accessing endpoint in the browser or directly in the settings for external data sources when accessing endpoint from different tools, for example, Salesforce Connect: 

See more:

https://skyvia.com/resources/docs/index.html?security_settings.htm

 

We will post here if any news regarding this sceanrio is available.

0
votes
Marina Seredova posted this 2 weeks ago

Ok, So cant we use the same type of authentication when we are using REST API to access the OData. 

We would be accessing the same endpoint and if user/pwd are setup then we should be able to pass as request headers for authentication?

1
votes
Mariia Zaharova posted this 2 weeks ago

Sorry for the misunderstanding, I did not get your question correctly. Skyvia Connect supports HTTP Basic Authentication. In case of Basic Authentication:

1) the username and the password must be combined with a colon - testuser:testpwd 

2) the resulting string is base64 encoded - dGVzdDp0ZXN0

 

For example, if you are using test as the userid and test as the password, then the field's value is the base64-encoding of test:test, or dGVzdDp0ZXN0. Then the Authorization header will appear as:

Authorization: Basic dGVzdDp0ZXN0

 

Is that what you were looking for?

  • Supported by
  • Marina Seredova
0
votes
Marina Seredova posted this 2 weeks ago

Thanks, yes this is what I was looking for. 

Close