2 Replies Latest reply on Sep 17, 2021 12:51 PM by Augustine Ken

    API - Add Data Steward to resource

    Steven Lane Active Member

      user181820

       

      I'm trying to add a user as a subject matter expert to a table on the data catalog.  I am getting an error 412 after posting the update to the data catalog.

       

      Any idea what would cause an error 412 "Precondition Failed"

       

      The way I am adding the data is grabbing the json tied to the resource, adding the user to the facts section then sending the entire json data through the post.  Let me know if this seems correct and what I can do to resolve the issue.

       

      Below is the JSON I am posting to the access/2/catalog/data/objects call.  I highlighted in red the addiition I made to the original JSON.

       

      {"items":[{

        "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW",

        "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW",

        "nativeId": 362775264,

        "facts": [

          {

            "attributeId": "com.infa.ldm.ootb.enrichments.dataOwner",

            "value": "Cheryl Pressley",

            "projectedFrom": "DomainUsers://User/southernco/CCPRESSL",

            "readOnly": false,

            "label": "Data Owner",

            "description": "Data Owner of the asset",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "attributeId": "core.resourceName",

            "value": "VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "readOnly": true,

            "label": "Resource Name",

            "description": "Name of the Resource",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "attributeId": "core.classType",

            "value": "com.infa.ldm.relational.Table",

            "readOnly": true,

            "label": "classType",

            "description": "Type of the object",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "attributeId": "com.infa.ldm.ootb.enrichments.subjectMatterExperts",

            "value": "Swapna Yamsani",

            "projectedFrom": "DomainUsers://User/southernco/SYAMSANI",

            "readOnly": false,

            "label": "Subject Matter Experts",

            "description": "User Description",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "attributeId": "core.name",

            "value": "TransformerEVW",

            "readOnly": true,

            "label": "name",

            "description": "Name of the object",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "attributeId": "core.resourceType",

            "value": "Microsoft SQL Server",

            "readOnly": true,

            "label": "Resource Type",

            "description": "Type of the Resource",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "attributeId": "com.infa.ldm.ootb.enrichments.dataSteward",

            "value": "Swaminathan Balasubramanian",

            "projectedFrom": "DomainUsers://User/southernco/SBALASUB",

            "readOnly": false,

            "label": "Data Steward",

            "description": "Data Steward of the asset",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "attributeId": "com.infa.ldm.relational.NativeType",

            "value": "TABLE",

            "readOnly": true,

            "label": "Native Type",

            "description": "",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "attributeId": "core.lastModified",

            "value": "2020-08-20T16:47:16.001Z",

            "readOnly": true,

            "label": "Last Modified",

            "description": "Last time the object was modified.",

            "providerId": "system",

            "xid": "n/a",

            "modifiedBy": "n/a"

          },

        {

            "attributeId": "com.infa.ldm.ootb.enrichments.subjectMatterExperts",

            "value": "Steven Lane",

            "projectedFrom": "DomainUsers://User/southernco/STEVLANE",

            "readOnly": false,

            "label": "Subject Matter Experts",

            "description": "User Description",

            "providerId": "enrichment",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/lookup/MeterForm",

            "modifiedBy": "southernco\\STEVLANE"

          }

        ],

        "srcLinks": [

          {

            "id": "DomainUsers://User/southernco/SYAMSANI",

            "href": "/2/catalog/data/objects/DomainUsers~3a~~2f~~2f~User~2f~southernco~2f~SYAMSANI",

            "readOnly": true,

            "association": "com.infa.ldm.ootb.enrichments.subjectMatterExperts",

            "linkProperties": [

              {

                "attributeId": "core.targetAttribute",

                "value": "com.infa.ldm.ootb.enrichments.subjectMatterExperts",

                "label": "Target Attribute"

              }

            ],

            "name": "Swapna Yamsani",

            "classType": "com.infa.ldm.isp.User",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "id": "DomainUsers://User/southernco/CCPRESSL",

            "href": "/2/catalog/data/objects/DomainUsers~3a~~2f~~2f~User~2f~southernco~2f~CCPRESSL",

            "readOnly": true,

            "association": "com.infa.ldm.ootb.enrichments.dataOwner",

            "linkProperties": [

              {

                "attributeId": "core.targetAttribute",

                "value": "com.infa.ldm.ootb.enrichments.dataOwner",

                "label": "Target Attribute"

              }

            ],

            "name": "Cheryl Pressley",

            "classType": "com.infa.ldm.isp.User",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "id": "DomainUsers://User/southernco/SBALASUB",

            "href": "/2/catalog/data/objects/DomainUsers~3a~~2f~~2f~User~2f~southernco~2f~SBALASUB",

            "readOnly": true,

            "association": "com.infa.ldm.ootb.enrichments.dataSteward",

            "linkProperties": [

              {

                "attributeId": "core.targetAttribute",

                "value": "com.infa.ldm.ootb.enrichments.dataSteward",

                "label": "Target Attribute"

              }

            ],

            "name": "Swaminathan Balasubramanian",

            "classType": "com.infa.ldm.isp.User",

            "providerId": "resource-attribute-propagation",

            "xid": "#Enrich#VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart_SQLServer_Database_Resource",

            "modifiedBy": "southernco\\STEVLANE"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging",

            "readOnly": true,

            "association": "com.infa.ldm.relational.SchemaTable",

            "linkProperties": [],

            "name": "staging",

            "classType": "com.infa.ldm.relational.Schema",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          }

        ],

        "dstLinks": [

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/SUB_UNIT_NAME",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~SUB_UNIT_NAME",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "SUB_UNIT_NAME",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/LONGITUDE",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~LONGITUDE",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "LONGITUDE",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/LOC_NUM",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~LOC_NUM",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "LOC_NUM",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/LOAD_VOLT_BANK",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~LOAD_VOLT_BANK",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "LOAD_VOLT_BANK",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/LAST_WE",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~LAST_WE",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "LAST_WE",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/ImportUser",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~ImportUser",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "ImportUser",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/FEEDERID",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~FEEDERID",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "FEEDERID",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/ImportDt",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~ImportDt",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "ImportDt",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/SUBTYPECD",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~SUBTYPECD",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "SUBTYPECD",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/PTAG",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~PTAG",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "PTAG",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/SUBSTATION_NAME",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~SUBSTATION_NAME",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "SUBSTATION_NAME",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/OBJECTID",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~OBJECTID",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "OBJECTID",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/PHASE_DESIGNATION",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~PHASE_DESIGNATION",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "PHASE_DESIGNATION",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/ORG_ID",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~ORG_ID",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "ORG_ID",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/DTM",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~DTM",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "DTM",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          },

          {

            "id": "VoltageAnalysisDataMart_SQLServer_Database_Resource://VoltageAnalysisDataMart/staging/TransformerEVW/LATITUDE",

            "href": "/2/catalog/data/objects/VoltageAnalysisDataMart_SQLServer_Database_Resource~3a~~2f~~2f~VoltageAnalysisDataMart~2f~staging~2f~TransformerEVW~2f~LATITUDE",

            "readOnly": true,

            "association": "com.infa.ldm.relational.TableColumn",

            "linkProperties": [],

            "name": "LATITUDE",

            "classType": "com.infa.ldm.relational.Column",

            "providerId": "MSSQLServerScanner",

            "xid": "VoltageAnalysisDataMart_SQLServer_Database_Resource##VoltageAnalysisDataMart#staging#TransformerEVW",

            "modifiedBy": "system"

          }

        ],

        "businessTerms": []

      }]}

       

      Thanks,

      Steve