get seesion from service user and in the service user I have provided the read and write permission for /content/dam folder

Query is failing to give results in dev cloud. There's no error just query results are 0. And same query is working when deployed to local. When I just run the query in dev crxde tools able to get the result. Via code trying to run failed get the results.

Hi, String sqlQuery = "SELECT * FROM [dam:Asset] AS asset " + "WHERE ISDESCENDANTNODE(asset, '/content/dam') " + "AND asset.[jcr:path] NOT LIKE '/content/dam/archive/%' " + "AND asset.[jcr:content/metadata/productdata/samsExpirationDate] IS NOT NULL " + "AND asset.[jcr:co...

Hi @EstebanBustamante , This asset is actually spinset. Using api it's returning spinset members as a results instead of reference asset path. Is this api applicable for spinset/imageset/mixedmediaset assets? 

Hi @EstebanBustamante , Tried both api not getting the result. Which asset path has to passed as params? can you please share the example code snippet.

Hi,I would like to know if there is a way to get the list of references of an asset through APIs.Thank you. 

yes @aanchal-sikka  

Hi @aanchal-sikka ,I have added this configuration for the workflow to be triggered in order. Still the same issue. Can you please check If I'm missing anything?Thank You

Workflow is getting triggered once for each asset.I have created 3 launchers for created, modified and delete.

Hi @Tethich ,1. Adding flag to the asset is not possible bcz we are checking the modified imagesets, spinsets and video. Then creating mediaset automatically. adding flag will be complicated.2. I tried adding those condition still same issue.