All CSV endpoints supported can be found here.
Public data is data that isn’t user data. To use these, simply fill cell
A1 on its own sheet (bottom-left tabs are “Sheets”) with the following:
If you are using a different locale (using a different number separator and such), you must also add
;",";"en_US" to the IMPORTDATA call. Effectively, what this does is say “the separator is comma and the locale of the data is en_US”. Doing this allows Google properly convert cells to numbers. An example using /csv/prices:
The use of private data endpoints requires you have a FIO account. Once your data is in FIO:
You can also use the private data endpoints with group ids as follows:
Groups are simply a mechanism of grouping users together. Groups do not imply that all members of the group share their data with each other. That being said, in order for groups to function as expected, all users in the group need to share their data via the
Permissions section of FIO settings.
Once this is done, select pages on FIO allow you to select a group. You can also use the group id for CSV private data endpoints.
Each user in the group must do the following:
FIDOread permission do your data.
Once that is complete, it is ready for use. To test, use the command:
$findmat RAT <GroupId>
<GroupID> is the groupid of the group.
If you are the owner (or administrator) of a discord server, you may set the default group id on a per-channel basis. Doing so means you can exclude the GroupId when typing any group commands. You can accomplish this by typing the following in a channel:
In order to reduce server load and make results return faster, FIDO maintains a per-user cache of results for 10 minutes. What this means is that the first command may be slow in returning the result, but subsequent ones will be faster. This also means that data may be out of date if something has changed immediately after the command was issued. To force clear your user cache, issue the following command:
The following group commands are available for use with FIDO:
Each of these commands require different inputs. Type
$help <Command> to see the help description.
To get FIDO into your own discord server: https://discord.com/api/oauth2/authorize?client_id=638095116615155722&permissions=51264&scope=bot