Export open actions

Export open actions

GET /exports/open-actions returns every current task in the workspace (up to 5,000) as one CSV file with a header row. Current means the task is open and is not snoozed into the future, the same as GET /tasks. The columns are the same task fields, in the same order.

Use it when a BI tool or spreadsheet needs the whole table, not a page of it. Power BI, Excel and Google Sheets re-download a table each time they refresh.

curl https://api.twelfth.ai/exports/open-actions \
  --header "Authorization: Bearer $TWELFTH_API_KEY" \
  --output open-actions.csv

Power BI

1. An owner or admin opens Settings → AI & agents and selects Create an API key, named for this report, for example “Power BI – open actions”. See API keys. Anyone who can open the report’s queries can read the key, so do not reuse a key from another integration.
2. In Power BI Desktop, choose Get data → Web, then Advanced.
3. Set URL parts to https://api.twelfth.ai/exports/open-actions.
4. Under HTTP request header parameters, enter Authorization and Bearer <your key>.
5. Choose OK. If Power BI asks how to sign in, choose Anonymous: the key in the header is the credential.
6. In Power Query, use the first row as headers and set dueAt to Date/Time/Timezone.

Or paste this into a blank query, with TwelfthApiKey as a text parameter:

let
    Source = Csv.Document(
        Web.Contents(
            "https://api.twelfth.ai/exports/open-actions",
            [Headers = [Authorization = "Bearer " & TwelfthApiKey]]
        ),
        [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]
    ),
    Promoted = Table.PromoteHeaders(Source, [PromoteAllScalars = true])
in
    Promoted

After you publish the report, set the data source credentials to Anonymous in the Power BI service and tick Skip test connection, then schedule a refresh. No gateway is needed. The Power BI guide has the full walkthrough.

Excel works the same way: Data → From Web → Advanced, with the same URL and header.

id,title,details,dueAt,bookKey,assigneeName,assigneeEmail,sourceSessionId,sourceTitle,sourceSummary,sourceKind
task_01JABCDEFGHJKMNPQRSTVWXYZ,Review the Nintendo order,,2026-10-21T03:00:00.000Z,dept:toys,Sam Lee,sam@example.com,,,,

Need another export?

Tell us which table you report on (projects, price gaps, products, history), the rows you expect, and how often the report refreshes.

Request an export

All endpoints · API compatibility