Metavault API - Get information mart script list

GetInformationMartScripts - GET

Path

/api/projects/{projectId}/informationmarts/{informationMartId}/scripts

Http Method

GET

Overview

Get the list of scripts associated to an information mart.

Required permissions

  • Read access to the Distribute module. Distribute read

Response

Success response (200 OK)

JSON
{
  "_embedded": {
    "informationMartScripts": [
      {
        "_embedded": {
          "columns": [
            {
              "name": "col1",
              "id": "0173d421-59fe-454a-a430-44594962bebc",
              "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
              "informationMartScriptId": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
              "comment": "the first column",
              "softRule": "SOFT_RULE",
              "sourceColumns": [
                {
                  "id": "479587d8-1c8d-4259-bfd9-150b0010fb18",
                  "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
                  "informationMartScriptId": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
                  "informationMartScriptColumnId": "0173d421-59fe-454a-a430-44594962bebc",
                  "entityType": "Hub",
                  "entityName": "h_Team",
                  "columnName": "bk"
                },
                {
                  "id": "434a2e29-dc5f-4517-ab86-75f7468435a6",
                  "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
                  "informationMartScriptId": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
                  "informationMartScriptColumnId": "0173d421-59fe-454a-a430-44594962bebc",
                  "entityType": "Satellite",
                  "entityName": "sh_Employee_info",
                  "columnName": "hdiff"
                }
              ]
            },
            {
              "name": "col2",
              "id": "0eaac712-c4a3-409b-9976-cbc5c8d8aa5f",
              "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
              "informationMartScriptId": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
              "comment": "oh ok",
              "softRule": "terrence",
              "sourceColumns": [
                {
                  "id": "b00207e7-c632-478a-9696-d5fd7a54c786",
                  "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
                  "informationMartScriptId": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
                  "informationMartScriptColumnId": "0eaac712-c4a3-409b-9976-cbc5c8d8aa5f",
                  "entityType": "Satellite",
                  "entityName": "sh_Team_info",
                  "columnName": "lead"
                }
              ]
            }
          ]
        },
        "name": "HMA1",
        "id": "8d12dd1d-a27e-4bdd-b4de-a500ac1d5639",
        "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
        "businessDescription": "",
        "technicalDescription": "",
        "tableName": "",
        "typeTag": "Custom",
        "order": 1,
        "timeout": 60,
        "code": "drop view if exists ..."
      },
      {
        "_embedded": {
          "columns": []
        },
        "name": "HMA2",
        "id": "be3da312-1a72-422a-bccb-9ef9a0743fe5",
        "informationMartId": "703a749d-37a2-4062-a3f9-3c283090fc92",
        "businessDescription": "",
        "technicalDescription": "",
        "tableName": "",
        "typeTag": "Custom",
        "order": 1,
        "timeout": 60,
        "code": "drop view if exists ..."
      }
    ]
  },
  "sort": [],
  "index": 0,
  "limit": 10,
  "expand": [],
  "total": 2
}