1 of 1 people found this helpful
Hi Steve, We don't have any API to fetch all the comments/reviews across catalog in one call.
We can get the comments/reviews only at object level.
You can start 'Following' the required assets, so that you will get notification when someone post a question or comments on assets in future.
The upcoming EDC version 10.4.1 has new Analytics features to track usage/participation in catalog. Please wait for the 10.4.1 release to explore more on this area.
How might this be accomplished in multiple calls? My thought would be to somehow get all tables and columns, then for each item, call the api to get the questions and comments.
Can you provide any examples of the individual calls to accomplish this? The main challenge for me is getting the api results of all tables and columns for example.
I have been able to query comments/questions once I got the object id.
Steven - what is your scripting language of choice?
for my - i prefer to use python - but any langage will do.
you can get all core.dataSet items (since questions can only be used for datasets) - and then check the dstLinks for com.infa.ldm.entity.collaboration.CollaborationCommentAssociation
you many not need to query again since a lot of information is listed there as linkProperties - including the collaboration.id and parentId
This sounds hopeful. I am using c#, but really, I just need to know the api calls and can handle the looping/additional calls as needed.
How would one go about getting all the core.dataSet items from the catalog via the api?
you can use the objects endpoint (2/catalog/data/objects) - passing a q (query) syntax to list all DataSet objects.
the query syntax could be:-
to get all datasets (dataset is a superclass - so any child class like com.infa.ldm.relational.Table com.infa.ldm.relational.View and others would be returned
or to filter for datasets within a specific resource name
or you could also filter on the resource type using core.resourceType
from there - you just need to read the json resultset and look at each object in the "items" collection, specifically dstLinks
you could also use some more filters to reduce the data that is returned - e.g.
This is great, thanks for that!
This query is intriguing: associations=com.infa.ldm.entity.collaboration.CollaborationCommentAssociation
will that return all items with comments in them?
There seems to be a lot of tribal knowledge regarding the api and how to query the objects. Are these options documented some where? Perhaps I have just missed them.
I would be interested in filtering further, getting all object with review and getting all object with comments associated to them.
You've been a big help...just ran my query like this:
http://<server name here>/access/2/catalog/data/objects?q=classType%3Acom.infa.ldm.relational.Table%20AND%20com.infa.ldm.entity.collaboration.CollaborationCommentAssociation&offset=0&pageSize=20&includeSrcLinks=false&includeDstLinks=true&includeRefObjects=false
I got some results, but it seemed to return a number of objects that did not have any comments or reviews in them. I assumed that is what com.infa.ldm.entity.collaboration.CollaborationCommentAssociation was for, correct? Please let me know where I am running awry here.
the associations parameter is a filter that takes a list of associations (full package name) and will only return those links (wheher found or not) it will not include any other associations.
using this technique is useful so you get less links returned (e.g. parent/child, summary and detailed lineage) for those objects.
what it does not do is search for items that only have those associations - we can't do that at the moment- you can only search for indexed attributes.
Do we any documentation for the API's for the rating as well and other types of asset following like source changes and enrichment?
Can you please help me with that?
Hi Amit! The documentation I've found most helpful is the swagger site itself, which also contains links to further documentation. Try going to your own internal swagger site first...
It should be at a url similar to this one:
Once you get to that site, you will see in the upper right hand corner of the screen a combobox for "Select a spec" this will let you switch between the different api calls that are available, both internal and standard. You can play with the calls there or use the links to additional documentation. Hope that helps!