Get files from File on Citrix

[jesuslogmein]

We need to connect to several xls files that are on a remote desktop. To access them manually, we do it with CITRIX, is there any way to configure a data source in Citrix so that I can connect or import those files?

thks!

[v-jianboli-msft · Accepted solution]

Hi @jesuslogmein ,

Please refer to the Citrix official document:  Accessing Monitor Service Data in Citrix Cloud

Similar to the steps for making API requests using MS Excel PowerQuery:

1. Open PowerBI

2. In PowerBI, go to Home menu > Get Data > click Blank Query

3. In the Power Query Editor window, go to Home menu > Query group > click Advanced Editor.

4. In the Advanced Editor window, type the following query:

let
    Source = OData.Feed
             (
"https://{ApiGatewayEndpoint}/Machines",
                          null,
                          [
                            Headers =
                                    [
                                        #”Authorization” = "<YourToken>",
                                        #"Citrix-CustomerId" = "<YourCustomerId"
                                    ]
                          ]
               )
in
    Source

Replace <YourCustomerId> and <YourToken> with the values of CustomerID and bearer token you obtained as described in the Generate the Citrix Cloud Bearer Token section. Make sure that the <YourToken> is in the format, “CWSAuth bearer= ”. Once the No Syntax errors have been detected is displayed in the bottom of the window, click Done.

5. In case of first login, a Please specify how to connect message is displayed. Click Edit Credentials, the Access an OData feed window appears. Make sure that the Anonymous tab and the base URL are selected and click Connect.

6. Upon successful authentication, the results are displayed as a table. In this example, the table lists all the Machines of the CustomerId. If the authentication fails, either the bearer token or the CustomerId might be invalid. Please verify the same and try again.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.