| Note |
|---|
As of Oct 3, 2022 Google will stop supporting the current oAuth flow. |
...
And the API version (e.g. v1.2)
| Code Block |
|---|
httphttps://[your-chilipublisher-url]/rest-api/[api-version]/system/server/googleauthcode |
Once created, you’ll get a client ID and Client secret that you will need in the CHILI publisher BackOffice.
URI in http or https?
On premise hosting | CHILI publisher Online | |
|---|---|---|
CHILI publisher is hosted in HTTP (non secure) | You must set the return API also to HTTP | Can NOT be hosted in HTTP |
CHILI publisher is hosted in HTTPS (secure) | You must set the return URI to HTTPS | You must set the return URI to HTTPS |
CHILI publisher side
In the CHILI publisher BackOffice, choose DataSources, and create a new DataSource, choose “Google Spreadsheets” as the type.
...
Provide the Client ID and Secret, and click “Get Access code”“Authorize”.
| Note |
|---|
If you just created the Credentials, and enabled the API’s, it could take a while. Consult the Google Cloud documentation to see what appropriate times are. |
...
You could remove the restrictions, but then your files / datasource might be accessible for too many people
Know restrictions
Applies when you have more than 1 Google SpreadSheet datasources defined.
When you have an open CHILI document, and want to select the second datasource, you’ll still see the files from the first selected datasource.
To see files from the other datasource, reload the file.