Connect UiPath to Cosmos DB to Read and Send docs

Help Studio
, ,
1

Hi,

Anyone connected Azure Cosmos CoreSQL to UiPath.

Regards,
AK

1 Like
2

Hey @Ashwini_Kumaran

If you can explain the issue will be better to suggest on that.

Also, Please find the tutorial below,

Hope this helps

Thanks
#nK

3

Hi Nithin,

I have connected to cosmos by making a HTTP call. Now it looks good.Thanks.

Regards,
Ashwini

1 Like
4

Great @Ashwini_Kumaran

5

Hi,
What authentication-method did you use?

I provide “AccountEndPoint” and "AccountKey"but i get error.
Could you please send a printscreen of your settings in the HTTP Wizard?
Thanks,
PIerre

6

This is the error message I get from HTTP-activity using AccessKey in OAuth2:

“message”: “Authorization header doesn’t confirm to the required format. Please verify and try again.\r\nActivityId: 95ff958d-1850-4a1a-aa84-a821bd1b2c12, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0”

7

I now get the following error, i greated the payload as per the instructions here:
Access Control on Azure Cosmos DB Resources | Microsoft Learn

Super greatful if anyone has any inputs. Thanks!

Error:

“Unauthorized","message":"The input authorization token can’t serve the request. The wrong key is being used or the expected payload is not built as per the protocol. For more info: Troubleshoot Azure Cosmos DB unauthorized exceptions | Microsoft Learn. Server used the following payload to sign: ‘get\ndbs\ndbs/Objects\nwed, 18 jan 2023 06:46:59 gmt\n\n’\r\nActivityId: 8a2a1284-bb43-46fc-b2d7-f810ad662803, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0"}”,

8

Hi @Ashwini_Kumaran Could you please share the authentication details for HTTP call. I am getting ‘Unauthorized’ error while trying to make an HTTP call although I believe authorization key has been correctly created as per the documentation.

9

Hi @paxel, Did you get any solution to this issue?

10

Hi yes, I used the following: ODBC driver for BI and analytics - Azure Cosmos DB | Microsoft Learn