Calling Citrix API

[Sudharshan1919]

Hi,

I Have a requirement to develop a report using the Citrix Data. To use the Citrix Data the data must be called using OData API.

Can someone help out with this issue, on how can i bring the citrix data to Power BI and Develop the Reports.

Thanks,

[v-easonf-msft · Accepted solution]

Hi, @Sudharshan1919 

Please refer to the Citrix official document  How to access Citrix Monitor Service data using the OData v4 endpoint 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,
Community Support Team _ Eason