read

Profile a spreadsheet the user uploaded to import as expenses, by its import_id. Returns the detected columns (which is

Changed on

Profile a spreadsheet the user uploaded to import as expenses, by its import_id. Returns the detected columns (which is the store / amount / date / label), the distinct values of the store column tagged as matches-a-store / not-in-account / blank, a count of refund (negative) rows, the full list of the user's stores, each store's expense categories, and a 10-row sample. ALWAYS call this first when a sheet is attached, then CONFIRM with the user how to map each store value, the currency, and whether to skip refunds before calling propose_expense_import.

post/api/v1/tools/inspect_expense_import

Request

  • Base URL: https://app.magistry.io
  • URL: https://app.magistry.io/api/v1/tools/inspect_expense_import
  • Auth: one of:
    • HTTP bearer
    • OAuth 2 (authorization code, authorization URL https://app.magistry.io/api/oauth/authorize, token URL https://app.magistry.io/api/oauth/token, scopes: costs:read)

Request body

import_idstring uuid required

The staged expense_imports id.

Response

Tool result

okboolean required
resultunknown required

Changes

  • 4a749f94b35cRevision changes
    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new app_not_reviewed enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status

    • warning

      added the new unsupported_behavior enum value to the response property for the response status