Elgato_dark/ToolJet
1
0
Fork 0
mirror of https://github.com/ToolJet/ToolJet synced 2026-04-21 21:47:17 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions 7
ToolJet/docs/versioned_docs/version-2.65.0/data-sources/appwrite.md
Pratik Agrawal abf6d516e3
[docs]: Update data-sources guides - appwrite, athena, azure blob (#10734) 
* [docs]: Update data-sources guides - appwrite, athena, azure blob

* Added padding befor h2

* Updated appwrite v2

* Updated appwrite v3

* Updated Athena v2

* Updated Azureblob v2

* Fix Typo in Athena
2024-09-18 14:18:35 +05:30

6.6 KiB
Raw Permalink Blame History

id title
appwrite Appwrite

ToolJet can connect to appwrite database to read/write data.

Connection

ToolJet connects to your Appwrite app using :

  • Host (API endpoint)
  • Project ID
  • Secret Key

You'll find the Secret Key and other credentials on your Appwrite's project settings page. You may need to create a new key if you don't have one already.

:::info You should also set the scope for access to a particular resource. Learn more about the API keys and scopes here. :::

To establish a connection with the Appwrite data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page from the ToolJet dashboard.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/connect-v3.png" alt="Appwrite intro"/>

Querying Appwrite

  • After setting up the Appwrite data source, navigate to the query panel and select the Appwrite data source that you added in the previous step.
  • After selecting Appwrite data source, select the operations that you want to perform on the Appwrite database and click Save to save the query.

<img style={{ border:'0', marginBottom:'15px' }} className="screenshot-full" src="/img/datasource-reference/appwrite/querying-v3.png" alt="Appwrite intro"/>

:::tip Query results can be transformed using Transformations. Read our Transformation documentation here :::

List Documents

This operation is used to get a list of all the user documents.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The value for collection ID field should be of String type.

Optional Parameters:

  • Limit: Maximum number of documents to return in the response. By default, it will return a maximum of 25 results. A maximum of 100 results is allowed per request. The Limit value should be of integer type.
  • Order fields: Array of attributes used to sort results. The order field value should be an array.
  • Order types: Array of order directions for sorting attributes. Possible values are DESC for descending order or ASC for ascending order. The order field value should be an array.
  • Field, Operator, and Value: For filtering the results, you can enter a field (attribute) name, use the appropriate operator from the dropdown, and set a value.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/list-v3.png" alt="Appwrite List" />

Get Document

Use this operation to get a document from a collection by its unique ID.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The value for collection ID should be of String type.
  • Document ID: Enter the document ID of the document that you want to get. The document ID should be of String type.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/get-v3.png" alt="Appwrite get" />

Add Document to Collection

Use this operation to create a new document in a collection.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The collection ID should be of String type.
  • Body: Enter the document data as a JSON object.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/add-v3.png" alt="Appwrite add" />

Update Document

Use this operation to update a document.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The value for collection ID should be of String type.
  • Document ID: Enter the document ID of the document that you want to get. The document ID should be of String type.
  • Body: Enter the document data as a JSON object.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/upd-v3.png" alt="Appwrite update" />

Bulk Update Using Document ID

Use this operation for bulk updating a document in a collection.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The value for collection ID should be of String type.
  • Key for document Id: Enter the key or attribute name that can be used to identify each record.
  • Records: The array of objects that will contain the data for updating each record in the database and these objects must contain a key-value pair to point unique record in the database (key for document)

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/bulk-v3.png" alt="Appwrite bulk update" />

Delete Document

Use this operation for deleting a document in the collection.

Required Parameters:

  • Collection ID: You can create a new collection using the Database service server integration or appwrite console. The value for collection ID should be of String type.
  • Document ID: Enter the document ID of the document that you want to get. The document ID should be of String type.

<img style={{ border:'0'}} className="screenshot-full" src="/img/datasource-reference/appwrite/del-v3.png" alt="Appwrite delete"/>