> For the complete documentation index, see [llms.txt](https://docs.buzzy.buzz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.buzzy.buzz/developing-and-extending-buzzy/buzzy-rest-api/datatabledata-tutorial.md).

# Datatabledata Tutorial

This tutorial will help you to learn how to interact with the Buzzy API endpoint for Datatable - the endpoint is called "microappdata"

For the canonical explanation of row metadata and `embeddingRowID`, see [Row Metadata and Relationships](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/row-metadata-and-relationships.md).

{% hint style="info" %}
Please note: Datatable were Previously called "Microapps", the name of the endpoint is thus microappdata.
{% endhint %}

### Prerequisites

To work with this tutorial you will need a version of [postman](https://www.postman.com/downloads). In addition a user with password that has access to a Buzzy server is required.

### Steps

1. Begin by creating a new request in postman. Set the request to POST and the url to yourserver/api/login. Set the body:

   ```
   {
    "email":"my-email@buzzy.buzz",
    "password":"my-password"
   }
   ```

   Click Send. The result should be a user id and token.

![tutorial-microappdata-postman1](https://1771273900-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3HPEoFCyP7Q88dV3CmqD%2Fuploads%2Fe6tvuEjSdIboC5G71tp3%2Ftutorial%20microappdata%20postman1?alt=media)

1. Now lets create a request to get the records from a Datatable. Create a new request in postman. Set the request to post and the url to yourserver/api/microappdata. Set two header key value pairs: X-User-Id and X-Auth-Token to the values returned in step 1.

<figure><img src="https://1771273900-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3HPEoFCyP7Q88dV3CmqD%2Fuploads%2FajgVuFKHDVbSlfL6m33n%2Ftutorial%20microappdata%20postman2?alt=media" alt=""><figcaption></figcaption></figure>

Add the Datatable id to the body:

```
{
	"microAppID":"<insert Datatable id here>"
} 
```

The DatatableId can be found by opening the Datatable in a browser and viewing the properties.

![tutorial-microappdata-postman3](https://1771273900-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3HPEoFCyP7Q88dV3CmqD%2Fuploads%2F7pXYDFMkLFBM7kvLUxE2%2Ftutorial%20microappdata%20postman3?alt=media)

Click Send, the result should be records from the Datatable best viewed as JSON.

![tutorial-microappdata-postman4](https://1771273900-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3HPEoFCyP7Q88dV3CmqD%2Fuploads%2FpXgaLdcjHAqyvnRQ4mG6%2Ftutorial%20microappdata%20postman4?alt=media)

Note that embedded Datatables are queried using this same endpoint. The body of the request contains the association:

```
{
    "microAppID": "<insert Datatable id here>",
    "searchFilter": [
        {
            "resourceID": "<insert Datatable id here>",
            "embeddingRowID": "<insert parent row id here>"
        }
    ]
}
```

The `embeddingRowID` stores the parent row ID for the child row relationship. Use it whenever you need to query the child rows that belong to one parent row.

***