Skip to main content

I have an Excel file that contains the SCI names, corresponding queries, folder name(workspace name), source connection name for each catalog item. I want to create a desktop plan which will help to generate the SCI though ONE Metadata writer or graphql query. Is there any possibilities to do that?

Hi ​@anik,
Yes, it’s definitely possible, using metadata writers in ONE Desktop and excel input you can create SQL CI’s in automated way.
First you’ll need to create a dslQueryCatalogItem entity, then create a dslQuery entity (child of the dslQueryCatalogItem) and once item is created and SQL query is populated you can trigger metadata import to export attribute details. However before doing this you’ll need to make sure you are able to find all the relevant related id’s as you’ll need to use them in the writers and json calls.

Here’s an example of the query that can be used in JSON call, it accepts 2 variable - connection and catalogItemId.
{"query":"query connection{\n connection(gid:\"#connectionId#\"){ \n gid,\n dslQueryMetadataImport(catalogItemId:\"#catalogItemId#\")\n }\n}"}

I hope this answers your question.
Ivan

Hi ​@ivan.kozlov,

 

Works perfectly. Thank you for your response.

Anik

Community Terms of Use & ConditionsCookie settingsAccessibility statement