> 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/rest-api/microapp-data-operations/microappdata-row.md).

# microappdata/row

### description

Returns one row of data from a Datatable (historically called a Microapp).

Use this endpoint when you already know the `rowID`. For the canonical explanation of row metadata, linked-table values, and `embeddingRowID`, see [Row Metadata and Relationships](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/row-metadata-and-relationships.md).

### parameters

The `X-Auth-Token` and `X-User-Id` are derived from the values `authToken` and `userId` returned from the login endpoint and are used in the HTTP header.

#### Resource

```
POST /api/microappdata/row
X-Auth-Token: <token goes here>
X-User-Id: <userID goes here>

{
	"rowID":"<insert row id here>"
}

```

### response

A JSON document with the row data. The returned row usually contains:

* row data fields for your app
* system-managed metadata such as `_id`, `userID`, `submitted`, `clientSubmitted`, and sometimes `embeddingRowID`

The success payload is returned as `body.currentRow`.

This endpoint is read-only. It does not accept field updates or metadata overrides.

### Private Data behavior

The `microappdata/row` endpoint follows the same row access, field access, viewer/team viewer, and [Private Data](/the-building-blocks/datatables-fields-and-data/private-data.md) rules as runtime screens.

* If the authenticated caller can view a Private Data field, the response can include the accessible value.
* If the caller cannot view the field, Basic Private Data is masked or redacted and Sensitive Private Data is hidden.
* Private Data file/image fields are controlled through the related [MicroAppChild API](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/microappchild.md).

Use this endpoint with the same least-privilege account model as `microappdata`.

### example

Fetch a single row by passing a `rowID`.

```
POST /api/microappdata/row
X-Auth-Token: <the authtoken you got back after authentication>
X-User-Id: <the userid you got back after authentication>

{
	"rowID":"cd34d53eddaad4aa55656bb5"
}
```

### linkedtable (crossapp row) field example

If the input Datatable row has a linked table (crossAppRow) field, then the target field information will be returned. Linked table fields create relationships between different tables in your app.

**Structure:**

* `crossAppRowID`: The `_id` of the linked row in another table
* `value`: Display information from the linked row
* `additionalValues`: Additional field values from the linked row (optional)

**Example Response:**

```
{
    "currentRow": {
        "organizationName": "Acme Corporation",
        "assignedUser": {
            "crossAppRowID": "5ee91f0c8b83524c3dd69dc8",
            "value": {
                "label": "name",
                "value": "John Smith"
            },
            "additionalValues": {
                "b1350a79a78e27a9c0715c95": {
                    "label": "email",
                    "value": "john.smith@acme.com"
                }
            }
        },
        "marketplaceListing": {
            "crossAppRowID": "marketplace-listing-id-123",
            "value": {
                "label": "listingName", 
                "value": "AI Customer Support Solution"
            },
            "additionalValues": {
                "field-id-456": {
                    "label": "category",
                    "value": "Customer Service"
                }
            }
        },
        "_id": "cd34d53eddaad4aa55656bb5",
        "userID": "1d88e48c3b08b536dfe0ebdf",
        "viewers": [],
        "isLocked": false,
        "submitted": 1614573289488,
        "deviceID": null,
        "appVersion": null,
        "hasConflict": false,
        "clientCounter": null,
        "clientSubmitted": "2021-03-01 (15:34:49) +1100"
    }
}
```

**Common Use Cases:**

* Connecting organizations to marketplace listings
* Assigning users to projects or tasks
* Linking products to categories
* Creating many-to-many relationships between data tables

### See Also

* [Row Metadata and Relationships](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/row-metadata-and-relationships.md) - Canonical metadata, `embeddingRowID`, and linked-table semantics
* [insertmicroapprow](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/insertmicroapprow.md#linked-table-field-example) - Inserting linked table fields
* [updatemicroapprow](/developing-and-extending-buzzy/buzzy-rest-api/rest-api/microapp-data-operations/updatemicroapprow.md#linked-table-field-update-example) - Updating linked table fields

***