> For the complete documentation index, see [llms.txt](https://docs.stellic.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.stellic.com/stellic-partner-api/exports/export-all-advising-notes.md).

# Export all advising notes

Use this endpoint to export your institution's advising notes, one row per note, oldest first. Deleted notes and drafts are left out. The export takes no filters and ignores query parameters other than `output_format` and `delivery_channel`. With more than 5,000 notes in total and no `delivery_channel`, it runs in the background, and you check its status with [`GET /get_export_url/`](/stellic-partner-api/exports/poll-an-async-export-and-fetch-its-presigned-url.md).

## GET /exports/all\_notes

>

```json
{"openapi":"3.0.0","info":{"title":"Stellic for Developers","version":"1.0"},"tags":[{"name":"Exports","description":"Institution-wide datasets as CSV or JSON. Small datasets come back inline; large ones run in the background and return a `file_name` you poll with `GET /get_export_url/` for a download link."}],"servers":[{"url":"https://{institution}.stellic.com/partnerapi/v1","variables":{"institution":{"default":"{institution}","description":"Your institution's Stellic subdomain: the part before `.stellic.com` in the URL you use to sign in. It becomes the host in every request, as in `https://{institution}.stellic.com/partnerapi/v1/...`. Replace the `{institution}` placeholder with your subdomain before sending."}}}],"security":[{"bearerAuth":[]}],"components":{"securitySchemes":{"bearerAuth":{"type":"http","scheme":"bearer","description":"Personal Access Token issued by your Stellic integration partner. Send it as `Authorization: Bearer <token>` on every request. One token per institution; do not share across environments."}}},"paths":{"/exports/all_notes":{"get":{"tags":["Exports"],"parameters":[{"name":"output_format","in":"query","required":false,"description":"Output format. `csv` (default) returns the file as CSV; `json` returns the same data as a JSON array of objects keyed by the column headers. Applies to both the inline and background paths. If you omit it and send the header `Accept: application/json` (exactly that value), the export is produced as `json`; an explicit `output_format` always wins.","schema":{"type":"string","enum":["csv","json"],"default":"csv"}},{"name":"delivery_channel","in":"query","required":false,"description":"`http_file` returns the file in the response at any size, `http_response` returns the same content without the attachment header at any size, and `s3` always runs the export in the background (poll `GET /get_export_url/` with the returned `data.file_name`). Setting this parameter skips the 5,000-note check. Omit it and the export runs in the background when there are more than 5,000 notes in total, excluding deleted notes and drafts. Query parameters other than `output_format` and `delivery_channel` are ignored.","schema":{"type":"string","enum":["http_file","http_response","s3"]}}],"responses":{"200":{"description":"**OK**\n- In the response (5,000 notes or fewer when `delivery_channel` is omitted, or any size with `delivery_channel=http_file` or `delivery_channel=http_response`): the CSV, or with `output_format=json` a JSON array of row objects. An empty export has only the CSV header row, or is `[]` in JSON.\n- In the background (more than 5,000 notes when `delivery_channel` is omitted, or any size with `delivery_channel=s3`): a JSON object with `bg_task` and `file_name` to poll.\n","content":{"application/json":{"schema":{"oneOf":[{"type":"array","items":{"type":"object"}},{"type":"object"}]}},"text/csv":{"schema":{"type":"string","format":"binary","description":"One row per note, oldest first; deleted notes and drafts are left out. Every note is included whatever its visibility, not only the notes the account behind your token can see. For concerns, `Severity` is `low`, `medium`, or `high`. `Created Date` is UTC, `YYYY-MM-DD HH:MM:SS`."}}}},"400":{"description":"Bad Request. An unsupported `output_format` or `delivery_channel` returns `{\"errors\": [\"Output format provided is currently not supported\"]}` or `{\"errors\": [\"Delivery channel provided is currently not supported\"]}`.","content":{"application/json":{"schema":{"type":"object"}}}},"401":{"description":"Unauthorized","content":{"application/json":{"schema":{"type":"object","properties":{"detail":{"type":"string"}}}}}},"403":{"description":"Your IP address isn't on the allowlist for this endpoint. Contact Stellic to add it; the response includes the `client_ip` Stellic saw.","content":{"application/json":{"schema":{"type":"object","properties":{"error":{"type":"string"},"message":{"type":"string"},"client_ip":{"type":"string"}}}}}}}}}}}
```

#### Columns

* `username`, `Student ID`, `First Name`, `Last Name`, `Email`: the student the note is about, blank for notes without one.
* `Note`: the note text, followed by `|` and the meeting minutes when there are any. A note with minutes and no text shows the minutes alone.
* `Note Type`: `concern`, `referral`, `kudos`, `meeting`, `review`, or `general`.
* `Assigned To`: who a concern, referral, or review is assigned to, such as a user's full name (or username, when the user has no name) or a group name.
* `Status`: `Open`, `Resolved`, or `Unresolved`, for concerns, referrals, and reviews.
* `Reason`: for concerns, `off-track`, `drop-in-performance`, `absence`, `financial`, or `other`; for kudos, `on-track`, `good-performance`, `improved-performance`, or `other`.
* `Severity`: for concerns, `low`, `medium`, or `high`.
* `Created Date` (UTC, `YYYY-MM-DD HH:MM:SS`), `Created By` (username), `Autogenerated` (`Yes` or `No`).
* `Note Tags` (tag names), `Course Codes`, and `Visibility` (any of `instructors`, `specific`, `student`, and `users_with_view_perm`). Several values are joined with `,` .

Columns that don't apply to a note's type are blank.

#### Notes

{% hint style="warning" %}
**Every note is included, whatever its visibility.** The export isn't limited to the notes the account behind your token can see, so treat the file as containing private advising records.
{% endhint %}

* For large files, choose background delivery rather than returning the file in the response.
* Poll [`GET /get_export_url/`](/stellic-partner-api/exports/poll-an-async-export-and-fetch-its-presigned-url.md) for completion using the same account that requested the export, rather than waiting for an email.
* **Check `status`, not only `url`.** On completion, polling normally returns a download URL. Depending on how Stellic has set up your institution, a completed response can instead have `url: null` and include `absolute_file_name`. Don't keep polling just because `url` is null; ask your Stellic Representative about file retrieval.
* An empty export is a CSV with only the header row, or `[]` in JSON.

#### Related APIs

* [`GET /exports/all_appointments`](/stellic-partner-api/exports/export-appointments.md) for appointments.
* [`GET /exports/{property}`](/stellic-partner-api/exports/bulk-export-dispatcher.md) for formats, delivery, and errors.