> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tangoanalytics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Mac request outbound

# Tango MAC Request Outbound API

> Generated from `Tango MAC Request Outbound API Integration Design Specification V1.1.docx` in SharePoint folder `03 Space Integrations`.
> OAS spec: [`mac-request-outbound.yaml`](./mac-request-outbound.yaml)

## Overview

Async **delta** REST API: client retrieves MAC requests created/updated in Tango since the last integration run. Two-call pattern with `gu_id` and pagination (5000/page).

**Owner:** Tango Analytics
**Spec version:** 1.1
**Status:** Draft (auto-generated — needs review)

## Endpoints

| Method | Path | Summary |
| - | - | - |
| GET | `/v1/spacemgmt/delta/moverequests` | Initiate delta export. |
| GET | `/v1/batch/status?gu_id=...&page_no=...` | Retrieve paginated records. |

## Integration logic

* Delta API; updates to `tango_request_id` do NOT trigger export.
* Null fields are omitted from response.

## Data model

| Field | Type | Notes |
| - | - | - |
| `request_type` | VARCHAR | Lookup. Sample: `NEW_HIRE` |
| `tango_request_id` | NUMBER | Tango internal request ID |
| `request_number` | VARCHAR | "MAC Number" |
| `ext_request_number` | VARCHAR | Client Integration ID |
| `requested_by` / `requested_for` | VARCHAR | Employee numbers |
| `requested_date` ⚠ | DATE | Sample `01-FEB-21` (DD-MON-YY) — different from MM/DD/YYYY elsewhere |
| `from_property` / `from_building` / `from_floor` / `from_space` / `from_area` | VARCHAR | Source location |
| `to_property` / `to_building` / `to_floor` / `to_space` / `to_area` | VARCHAR | Destination location |
| `from_locker` / `to_locker` | VARCHAR | |
| `first_name` / `last_name` | VARCHAR | Of the requested-for person |
| `effective_date` | DATE | |
| `justification` / `notes` | VARCHAR | |
| `mac_group` | – | Type/sample not in mapping table |
| `status` | VARCHAR | Request Status (lookup) |
| `update_only` ⚠ | – | No type/sample in source — confirm semantic |
| `last_update_date` | TIMESTAMP | ISO 8601 sample `2025-07-29T09:57:48` |
| `last_updated_by` | VARCHAR | |
| `c_ext_attr1..10` / `c_ext_lov1..5` / `n_ext_attr1..5` / `d_ext_attr1..5` | – | Custom attributes |

## Open Questions / Assumptions

* [ ] **`requested_date` sample format `01-FEB-21`** (DD-MON-YY) is inconsistent with `last_update_date` ISO 8601 format. Confirm.
* [ ] **`update_only` field** has no type or sample in the mapping table. Semantic unclear — confirm.
* [ ] **No required-field column** in source mapping.
* [ ] **Source has many smart quotes** in JSON sample (curly quotes vs straight) — doc-formatting artifact, not wire format.

## Changelog (compressed)

| Ver | Date | Description | Author |
| - | - | - | - |
| 0.1–1.0 | 2022-2025 | (see source doc) | Various |
| 1.1 | 04/22/2026 | Updated API architecture diagram | Alpna Bansal |