DQL query with select * not returning all the properties in API response

Question

Hi Everyone

I have been trying to work on DQL to get the documents based on specific modify date to extract the properties/metadata and i have used below API where select query is being used to retrieve all the fields but its not retrieving all the properites

{URL}/repositories/{repo_name}?dql=select+*+from+{object_model}+where+r_modify_date+>+DATE('19/01/2026+12:28:18',+'dd/mm/yyyy+hh:mi:ss')+and+FOLDER('/{folderpath}',+DESCEND)+and+object_name+in+('{object_name}')+ENABLE(FETCH_ALL_ROWS+0)&items-per-page=1000&raw=true

example:

i_chronicle_id,a_full_text,r_content_size etc. are missing and i want to extract all the metadata

please provide me the solution or documentation where i can refer!

Michael McCollough · Answer

The rest endpoint for DQL returns key attribute when * is used. You can get more but you have to specify them.

I used your select * but added specific attributes after:

servername/cl-rest/repositories/McCollough?dql=select *,i_chronicle_id,a_full_text,r_content_size from dm_document where folder(%27/Templates%27)

AlvaroDeAndresGomez · Answer

the dql endpoint doesn't know which type are you querying, therefore it only returns a (common) subset of attributes. If you want all attributes you should either list them on the select clause, or use the associated link that you get with the dql result, which points to the individual object's endpoint (ie: dctm-rest/repositories//documents/