How to tag Alteryx Connect data source entities like database/table/column using REST API?

[mohitjoshi]

I want to add tags to the data source entities like database, table, column using Alteryx Connect REST API.  

[BenMoss]

Hi There, I am looking at using the tags feature in order to automatically categorise any workflows that come from a specific Alteryx Server instance as 'development'.

I've followed the instructions outlined in the solution and I have succesfully loaded data into the 'LOADED_TAGS' table, as show in the screenshot below...

However when I navigate to one of these XID's via the Alteryx Connect UI the tags are not displaying, as shown in the image below...

Is there a specific job that needs to be executed in order to display these items in the UI?

Ben

[BenMoss]

Investigating this a bit more it seems like the relationships aren't getting created between the tags and workflows. There is nothing in this thread to suggest additional development is required beyond loading data into the 'LOAD_TAGS' table with the respective parents XIDs.

@OndrejC @PetrH can you advise?

[PetrH]

Hi @BenMoss ,

first of all this is stage table maintained by the loaders.
In this case its called for example in database loaders Google BigQuery and Azure data catalog, but only for the related objects. 

Its not working by default -  for example on your case for workflows.
to make it working, it would require to customize sync job, which is not really recommended and it needs to be re-implemented on each upgrade.

I am also concerned, that the subject of this thread is update tags by API which means the setting this by accessing connect endpoints not stage tables.

[BenMoss]

Thank you again @PetrH .

I've worked extensively with the API over the last week. To me it seems the way in which you would add tags to an asset in an automated fashion would be through the 'Upload File' endpoint. Is that correct? I don't see how any of the other end-points could be utilized in this scenario.

Ben