Follow steps 1 to 4 to add the Jsonimport functionality:

• https://www.lido.app/tutorials/json-to-google-sheets

Step 2 – Prepare your SynthesisVR Leaderboard URL

• https://synthesisvr.com/knowledge-base/reading-leaderboard-through-api/

Step 3 – Create a new Google Sheets file

Add 3 empty sheets:

• SynthesisData — this Sheet will hold the data coming from Synthesis
• AnalyzedData — will hold the sorted data
• PublicView — will hold the final with the best results per player

SynthesisData:

Copy/paste the following formula under A1:

=QUERY(IMPORTJSON("https://api.synthesisvr.com/data/leaderboard/11111111-1111-1111-1111-111111111111/1371/3%20month",,"","noTruncate"),"SELECT Col13,Col14,Col11,Col7,Col8,Col15 WHERE Col13 IS NOT NULL")

Don’t forget to replace 11111111-1111-1111-1111-111111111111 with your actual Synthesis API key.

AnalyzedData:

Copy/paste the following formula under A1:

=QUERY(SynthesisData!A2:N10000,"SELECT A ,B,C,D,E,F ORDER BY C DESC")

PublicView:

Copy/paste the following formula under A1:

=UNIQUE(AnalyzedData!A:B)

Copy/paste the following formula under C1:

• =MAXIFS(AnalyzedData!C:C,AnalyzedData!A:A,A1,AnalyzedData!B:B,B:B)
• .. drag C1 down, so it can auto-fill the highest score ..

Step 4 – Enable the automated Google Sheets hourly synchronization

Under Google Sheets, click on “File” and select “Settings”. Switch to the “Calculation” tab and switch the “Recalculation” period to “On change and every hour”.

Step 5 – Manage the Sheet permissions

For the SynthesisData and AnalyzedData Sheets – click the down arrow next to the name and select the “Hide” option:

You can now share the Leaderboard publicly. Make sure people not belonging to your organization are not allowed to make changes to the file.

The post How to auto-sync Leaderboard data to Google Sheets appeared first on Synthesis VR.

1. Under SynthesisVR Web Administration portal, navigate to “Administration >> Arcade Setup >> SynthesisVR Subscriptions” and get your stations subscribed for “Leaderboard Application” (it is free for stations that are already subscribed for the full SynthesisVR version).
   Note: If you are offering Project CARS Pro, you have to also subscribe for the “Project CARS Pro Leaderboard” plugin.
2. Upon subscription, click the Refresh button for all your Access Point instances
3. Go to https://games.synthesisvr.com/games/synthesisvr-leaderboard and click the “Install SynthesisVR Leaderboard” button. The application can be installed on ANY Windows based PC in your local area network.
4. Run the installer, follow the steps and launch the application.
5. You are presented with an option to install Plugins. Do that for the games you are offering.

Optional:

• Go to “Administration >> Games & Licensing >> Your Games”. Find one of the supported games and click on it. Under the popup, switch to the “Plugins” tab and install the “Customer Name” plugin. This will allow you to click on the station name under the “Your Arcade” page and change the customer name on the fly (doesn’t require a running session).

The post Leaderboard Add-on – Getting Started appeared first on Synthesis VR.

2. Head to the API & Webhooks tab and click on the + button on the top right:

 
Make sure the leaderboard permission is assigned.
If the “Strict Access” option is enabled, you will be able to access the collected data ONLY from an IP address associated with your location.

3. Prepare the following URL:

• https://api.synthesisvr.com/data/leaderboard/<API_KEY>/<GAME_ID>/<DURATION>

Example:

• https://api.synthesisvr.com/data/leaderboard/11111111-1111-1111-1111-111111111111/15/6 month

Upon refreshing the Widgets page, you’ll be able to locate your API key:

 
Game ID — keep it to 0 (zero) if you want to fetch information about all the collected games. Based on that response, you’ll be able to see and use specific game ids
Duration — any combination of <number> + <period>. Examples:

• 5 days
• 17 days
• 117 days
• 2 months
• 2 months 13 days
• 7 months 2 days
• 1 year

The API response data is formatted as JSON and have the following structure:

 
The “score” object itself contains:

info = raw data extracted from the game (differ between the games)
score = SVR attempt to recognize and extract the score from the info object
customer = the customer associated with the SynthesisVR session. In a multi-station session, the data don’t necessary correlate with the actual player.
utcepoch = the UTC epoch when the leaderboard record is logged (you can look up the exact date/time in any programming language ; online example: https://www.epochconverter.com/)
 

The post Reading Leaderboard Through API appeared first on Synthesis VR.