Authentication
To start using the endpoints of our APIs, you must first authenticate. This guide explains how to obtain and use authentication credentials with the Sheetize Cloud platform.
Main Features
The authentication flow of Sheetize Cloud is designed to protect your data and ensure that only authorized users can upload files and invoke our services. It provides:
- Secure, token-based access that can be revoked at any time.
- Support for both machine-to-machine and user-driven scenarios.
- Granular scopes that let you limit what a token can do.
How To Use
Create an application
- Go to the Dashboard
- After logging in, click the **Applications** menu item on the left-hand navigation bar.
- Press **Create New Application** to open the application-creation form.
- In the *Application Details* section, enter a descriptive name and a short description for your application.
- Click the **Save** button to store the new application.
- In the list of applications, locate the one you just created and click its name.
- In the *Client Credentials* panel you will see a **Client ID** and a **Client Secret** - keep these values safe; they will be required to obtain an access token.
Obtain An Access Token
-
Make a request to the Authenticator endpoint
https://api.sheetize.cloud/authenticator/token?ClientId=TheClientId&ClientSecret=TheClientSecret - After the execution you will receive the token, please store it for later use
Use The Endpoints
- Choose the API you wish to call. In this example we demonstrate the Conversion service, which transforms spreadsheet files into PDF format.
-
Send a request that includes the files and the access token Conversion API
curl -X 'POST' \ 'https://api.sheetize.cloud/conversion/to-pdf' \ -H 'accept: text/plain' \ -H 'Authorization: Bearer The_Secret_Access_Token \ -H 'Content-Type: multipart/form-data' \ -F 'UploadFileRequest.OperationId=' \ -F 'UploadFileRequest.Files=@TestFile.xlsx;type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' -
The service will respond with a download URL for the generated PDF, in this example it is:
{ "name": "", "type": "1", "size": 900000, "description": "", "linkToDownload": "/download/AFolderName/AFileName.pdf", "message": "", "statusCode": 200 } -
Send a request that includes the file name and the folder name to Download API
curl -X 'GET' \ 'https://api.sheetize.cloud/download/TheFolderName/TheFileName.pdf' \ -H 'accept: */*' \ -H 'Authorization: Bearer TheAccessToken' - You will receive the file and you can either use it or simply forward it to the next step of your workflow.