Orion Advisor Solutions

Orion Advisor Solutions Utility/Grid Export API

The Utility/GridExport API from Orion Advisor Solutions — 3 operation(s) for utility/gridexport.

GitHub OpenAPI

Operations 3

POST /v1/Utility/GridExport Queues an export for the described view. #
POST /v1/Utility/GridExport/Count Counts the rows the described view would export. #
GET /v1/Utility/GridExport/Run/{filename} Downloads a previously generated export #

Specifications

⚙
OpenAPI
https://artifacts.apis.io/orion-advisor-solutions/openapi/orion-advisor-solutions-utility-gridexport-api-openapi.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/orion-advisor-solutions:orion-advisor-solutions-utility-gridexport-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

orion-advisor-solutions-utility-gridexport-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: V1
  title: Orion Connect Utility/Grid Export API
  x-swagger-net-version: 8.4.12.001
servers:
- url: https://api.orionadvisor.com/api
tags:
- name: Utility/GridExport
paths:
  /v1/Utility/GridExport:
    post:
      tags:
      - Utility/GridExport
      summary: Queues an export for the described view.
      operationId: GridExport_ExportAsync
      parameters:
      - name: cancellationToken
        in: header
        required: true
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: object
            application/json:
              schema:
                type: object
            text/json:
              schema:
                type: object
            multipart/form-data:
              schema:
                type: object
      security:
      - Authorization: []
      requestBody:
        content:
          text/plain:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          application/json:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          text/json:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
        required: true
  /v1/Utility/GridExport/Count:
    post:
      tags:
      - Utility/GridExport
      summary: Counts the rows the described view would export.
      operationId: GridExport_CountAsync
      parameters:
      - name: cancellationToken
        in: header
        required: true
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
            application/json:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
            text/json:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
            application/xml:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
            text/xml:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
            multipart/form-data:
              schema:
                $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto'
      security:
      - Authorization: []
      requestBody:
        content:
          text/plain:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          application/json:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          text/json:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto'
        required: true
  /v1/Utility/GridExport/Run/{filename}:
    get:
      tags:
      - Utility/GridExport
      summary: Downloads a previously generated export
      operationId: GridExport_RunAsync
      parameters:
      - name: filename
        in: path
        description: The filename provided by the generate endpoint.
        required: true
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                type: object
            application/json:
              schema:
                type: object
            text/json:
              schema:
                type: object
            multipart/form-data:
              schema:
                type: object
      security:
      - Authorization: []
components:
  schemas:
    OAS.WebApi.DTO.Utility.GridExport.GridExportCountResultDto:
      description: Row count for the user's current filters, used to drive the record limit banner.
      properties:
        count:
          type: integer
          format: int32
        maxRows:
          type: integer
          format: int32
        exceedsMaxRows:
          type: boolean
      xml:
        name: GridExportCountResultDto
      type: object
    OAS.WebApi.DTO.Utility.GridExport.GridExportColumnDto:
      properties:
        field:
          description: The DTO property the column reads, matching the field sent on the grid's colDef.
          type: string
        headerName:
          type: string
        dataType:
          description: One of the {OAS.WebApi.DTO.Utility.GridExport.GridExportColumnDataTypes} values. Drives the Excel number format.
          type: string
        decimalPlaces:
          type: integer
          format: int32
      xml:
        name: GridExportColumnDto
      type: object
    OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto:
      description: 'Describes an export in terms of the user''s current grid view instead of a payload of row data.

        The server replays the grid''s own query using {OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto.Query} and shapes the file using

        {OAS.WebApi.DTO.Utility.GridExport.GridExportRequestDto.Columns}, so the export reflects every row matching the user''s filters rather than

        only the rows the browser happens to hold.'
      properties:
        gridKey:
          description: Identifies which registered grid export source fulfills this request.
          type: string
        downloadName:
          type: string
        query:
          $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportQueryDto'
        columns:
          description: The visible columns, in display order.
          items:
            $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportColumnDto'
          xml:
            name: GridExportColumnDto
            wrapped: true
          type: array
        options:
          $ref: '#/components/schemas/OAS.WebApi.DTO.Utility.GridExport.GridExportOptionsDto'
      xml:
        name: GridExportRequestDto
      type: object
    OAS.WebApi.DTO.Utility.GridExport.GridExportQueryDto:
      properties:
        filter:
          description: OData v3 $filter translated from the grid's filter model.
          type: string
        orderBy:
          description: OData v3 $orderby translated from the grid's column sort state.
          type: string
        scope:
          description: 'Grid specific parameters that OData cannot express, such as the Billing Accounts category

            and the Active/Inactive/All selection. The shape is owned by the grid''s export source.'
          type: object
      xml:
        name: GridExportQueryDto
      type: object
    OAS.WebApi.DTO.Utility.GridExport.GridExportOptionsDto:
      properties:
        sheetName:
          type: string
        utcOffsetMinutes:
          description: 'Shifts exported date values so times match what the user saw in their own time zone.

            Matches the utcOffsetMinutes convention used by the SlickGrid export.'
          type: integer
          format: int32
        maxRows:
          description: Caller requested row ceiling. Clamped to the server maximum.
          type: integer
          format: int32
        skip:
          description: Rows to skip before materializing the next batch of a multi-file export.
          type: integer
          format: int32
        batchNumber:
          description: One-based part number when the export is split across multiple files.
          type: integer
          format: int32
        totalBatches:
          description: Total number of files the client expects for this export.
          type: integer
          format: int32
      xml:
        name: GridExportOptionsDto
      type: object
  securitySchemes:
    Authorization:
      type: apiKey
      description: 'JWT Authorization header using the Session scheme. Example: "Authorization: Session {token}"'
      name: Authorization
      in: header