clock for blog

Office Hours
Mon-Fri 09:00-21:00

Knowledgebase: Skinning and API
Export Gizmo Data (Users, hosts, products etc) to excel
Posted by Panagiotis Mantzouranis on 08 April 2019 03:35 PM

You can use Gizmo API system to export raw data in a .json format and, using an online converter, convert the data to excel, word, pdf and other formats

 

To use the API system first you need to make sure it is enabled. Enabling the "Web portal" also enables the API functionality

Now, open a web browser and navigate to your server ip. If you are working directly on the Gizmo server pc, use:

http://127.0.0.1:80/

If you are using a different port number in the settings, make sure you adjust the URL accordingly

You should now be greeted with the Gizmo service main web page

Click on Resources - Web API

For example: To export users, click on the API Name: User option and then on Description: Gets all users. Enter your Gizmo manager account when asked.

The users will be displayed in a standard .json format. Right-click on the screen and select "save as" and save the .json file

Now open https://www.aconvert.com/document/json-to-xlsx/, a free web-based converter. To convert, do the following:

  1. Select .json file
  2. Select export format
  3. Press convert
  4. Click on the converted file to save

 

Below is a list of data you can export:

Data API URL
User list http://127.0.0.1:80/api/user
All product list http://127.0.0.1:80/api/product
Time offers only list http://127.0.0.1:80/api/product/time
Host list http://127.0.0.1:80/api/host
Computer only list http://127.0.0.1:80/api/hostcomputer
Application list http://127.0.0.1:80/api/app
Application list (titles Only) http://127.0.0.1:80/api/app/titles
Invoice list http://127.0.0.1:80/api/invoice
Monetary units http://127.0.0.1:80/api/monetaryunit
News feeds http://127.0.0.1:80/api/news
RSS news feeds http://127.0.0.1:80/api/feed
Total spending by user http://127.0.0.1:80/api/reports/user/spending
Total Points by user http://127.0.0.1:80/api/reports/user/points/award
Custom attributes list http://127.0.0.1:80/api/attribute
(1 vote(s))
Helpful
Not helpful