Gemini has a powerful API which allows you to interact with Gemini in more ways.
One way, is to use Excel to create a query and pull data from Gemini. This guide will show you how to retrieve a list of users currently in Gemini.
Firstly, open Excel and navigate to the Data ribbon.
Then click on “Get Data” and select From Other Sources and From Web
Then, you will need to switch to the advanced mode, because you will need to provide credentials to access your Gemini instance. In this example, we’re connecting to a local environment, but you should put your Gemini url into the first box. Then the API route you wish to call. For the docs on the API please see the Countersoft’s own documentation for this
If you are using Forms authentication, you will need to add an HTTP Header to authenticate your request to the API.
In this example, and as stated in Countersoft’s documentation, it uses the keyword “Basic” plus a space, and followed by base 64 bit (utf8) encoding of the username and API key, eg, Base64.encode("manager:xvitjc5bmm").
Click OK, and it should connect and download some records.
Obviously, this is not much use at the moment, it merely tells us there are 500+ users available. However, this is the correct query to setup. Now, we just need to massage the data to be in a useful format.
Click the To Table button and accept the defaults:
This results in a table, but still not at all useful because it still just shows “Record”.
Now, we need to expand out the data to show something meaningful. Gemini sends a DTO object which wraps the entity and provides other information which may be of use, however, in this case we will just look at the BaseEntity property which has the basic user data. (Though not all, for security reasons the passwords are not sent!)
Click the Expand icon to the right of the column:
In this example, we will just select the BaseEntity property, and, unless you want really long header names, remove the check to use original column names as prefix option:
Then repeat this again, but this time it is expanding the BaseEntity property:
Select the fields you wish to include in your extract and click OK:
Now you can see the data requested from the API.
One way, is to use Excel to create a query and pull data from Gemini. This guide will show you how to retrieve a list of users currently in Gemini.
Firstly, open Excel and navigate to the Data ribbon.
Then click on “Get Data” and select From Other Sources and From Web
Then, you will need to switch to the advanced mode, because you will need to provide credentials to access your Gemini instance. In this example, we’re connecting to a local environment, but you should put your Gemini url into the first box. Then the API route you wish to call. For the docs on the API please see the Countersoft’s own documentation for this
If you are using Forms authentication, you will need to add an HTTP Header to authenticate your request to the API.
In this example, and as stated in Countersoft’s documentation, it uses the keyword “Basic” plus a space, and followed by base 64 bit (utf8) encoding of the username and API key, eg, Base64.encode("manager:xvitjc5bmm").
Click OK, and it should connect and download some records.
Obviously, this is not much use at the moment, it merely tells us there are 500+ users available. However, this is the correct query to setup. Now, we just need to massage the data to be in a useful format.
Click the To Table button and accept the defaults:
This results in a table, but still not at all useful because it still just shows “Record”.
Now, we need to expand out the data to show something meaningful. Gemini sends a DTO object which wraps the entity and provides other information which may be of use, however, in this case we will just look at the BaseEntity property which has the basic user data. (Though not all, for security reasons the passwords are not sent!)
Click the Expand icon to the right of the column:
In this example, we will just select the BaseEntity property, and, unless you want really long header names, remove the check to use original column names as prefix option:
Then repeat this again, but this time it is expanding the BaseEntity property:
Select the fields you wish to include in your extract and click OK:
Now you can see the data requested from the API.
Comments
Post a Comment