Orion Advisor Solutions

Orion Advisor Solutions Query Studio/Related Columns API

The QueryStudio/RelatedColumns API from Orion Advisor Solutions — 3 operation(s) for querystudio/relatedcolumns.

GitHub OpenAPI

Operations 4

GET /v1/QueryStudio/RelatedColumns Related column get related columns async #
POST /v1/QueryStudio/RelatedColumns Related column create related column async #
DELETE /v1/QueryStudio/RelatedColumns/{id} Related column delete related column async #
GET /v1/QueryStudio/RelatedColumns/Columns Related column get columns for source name async #

Documentation

📖
Documentation
https://developers.orionadvisor.com/quick-start/
📖
Documentation
https://developers.orionadvisor.com/guides/
📖
APIReference
https://api.orionadvisor.com/api/swagger/ui/index
📖
GettingStarted
https://developers.orionadvisor.com/quick-start/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/orion-advisor-solutions/refs/heads/main/openapi/orion-advisor-solutions-querystudio-relatedcolumns-api-openapi.yml

Other Resources

🔗
Webhooks
https://raw.githubusercontent.com/api-evangelist/orion-advisor-solutions/refs/heads/main/asyncapi/orion-advisor-solutions-webhooks.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-querystudio-relatedcolumns-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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-querystudio-relatedcolumns-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: V1
  title: Orion Connect Query Studio/Related Columns API
  x-swagger-net-version: 8.4.12.001
servers:
- url: https://api.orionadvisor.com/api
tags:
- name: QueryStudio/RelatedColumns
paths:
  /v1/QueryStudio/RelatedColumns:
    get:
      tags:
      - QueryStudio/RelatedColumns
      operationId: RelatedColumn_GetRelatedColumnsAsync
      parameters:
      - name: cancellationToken
        in: header
        required: true
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
            text/json:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
            application/xml:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
            text/xml:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
            multipart/form-data:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
                xml:
                  name: RelatedColumn
                  wrapped: true
                type: array
      security:
      - Authorization: []
      summary: Related column get related columns async
      x-summary-source: derived
    post:
      tags:
      - QueryStudio/RelatedColumns
      operationId: RelatedColumn_CreateRelatedColumnAsync
      parameters:
      - name: cancellationToken
        in: header
        required: true
      responses:
        '204':
          description: No Content
      security:
      - Authorization: []
      requestBody:
        content:
          text/plain:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          application/json:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          text/json:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          application/xml:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          text/xml:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/OAS.DataModel.QueryStudio.RelatedColumn'
        required: true
      summary: Related column create related column async
      x-summary-source: derived
  /v1/QueryStudio/RelatedColumns/{id}:
    delete:
      tags:
      - QueryStudio/RelatedColumns
      operationId: RelatedColumn_DeleteRelatedColumnAsync
      parameters:
      - name: id
        in: path
        required: true
        schema:
          type: integer
          format: int32
      - name: cancellationToken
        in: header
        required: true
      responses:
        '204':
          description: No Content
      security:
      - Authorization: []
      summary: Related column delete related column async
      x-summary-source: derived
  /v1/QueryStudio/RelatedColumns/Columns:
    get:
      tags:
      - QueryStudio/RelatedColumns
      operationId: RelatedColumn_GetColumnsForSourceNameAsync
      parameters:
      - name: sourceName
        in: query
        required: true
        schema:
          type: string
      - name: cancellationToken
        in: header
        required: true
      responses:
        '200':
          description: OK
          content:
            text/plain:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
            text/json:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
            application/xml:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
            text/xml:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
            multipart/form-data:
              schema:
                items:
                  $ref: '#/components/schemas/OAS.DataProcess.QueryStudio.QueryTags.TableColumn'
                xml:
                  name: TableColumn
                  wrapped: true
                type: array
      security:
      - Authorization: []
      summary: Related column get columns for source name async
      x-summary-source: derived
components:
  schemas:
    OAS.DataModel.QueryStudio.RelatedColumn:
      properties:
        id:
          type: integer
          format: int32
        columnName:
          type: string
        sourceName:
          type: string
        relatedColumnName:
          type: string
        relatedSourceName:
          type: string
        auditedDate:
          type: string
          format: date-time
        auditedByDisplay:
          type: string
      xml:
        name: RelatedColumn
      type: object
    OAS.DataProcess.QueryStudio.QueryTags.TableColumn:
      properties:
        id:
          type: integer
          format: int32
        dataType:
          type: string
        isNullable:
          type: boolean
        columnName:
          type: string
        tableName:
          type: string
      xml:
        name: TableColumn
      type: object
  securitySchemes:
    Authorization:
      type: apiKey
      description: 'JWT Authorization header using the Session scheme. Example: "Authorization: Session {token}"'
      name: Authorization
      in: header