How can I get total number of update/create actions on a weekly and monthly basis?

Question

We need to report statistics (mainly creation/update of records) on a weekly and monthly basis. We have been unable to gather this information using the following API.

GET https://<envirnoment>.reltio.com/reltio/api/<tenantID>/entities?filter=(range(updatedTime,1615593600000,1615766400000) and lt(createdTime,1615593600000))&select=uri&max=100.

Answer

Alternative 1 (using activities API)

Using the activities API to get the total where entities were changed during a time period.

GET https://<environment>.reltio.com/reltio/api/<tenantId>/activities/_total?filter=(range(items.timestamp,1615593600000,1615766400000) and (equals(items.data.type, "ENTITY_CHANGED"))

Using the activities API to get entities where entities were changed during a time period.

GET https://<environment>.reltio.com/reltio/api/<tenantId>/activities?filter=(range(items.timestamp,1615593600000,1615766400000) and (equals(items.data.type, "ENTITY_CHANGED"))

 

Using the activities API to get entities where entities were changed or created during a time period.

GET https://<environment>.reltio.com/reltio/api/<tenantId>/activities?filter=(range(items.timestamp,1615593600000,1615766400000) and ( (equals(items.data.type, "ENTITY_CHANGED") or (equals(items.data.type, "ENTITY_CREATED") ) )

Alternative 2 (Using GBQ in Analytics/Reporting RI)

• Activity in total for specific entities within a particular time period

SELECT   *
FROM `<activity_table_for_tenant>`
WHERE 
  activityTimestamp BETWEEN '20200515' AND '20200515'  
 AND objectUri in ("RyvSG5t", "CWqgCpH", "7J8oeRC", "7JAgYYI", "5aTXFMl")
 order by timestamp desc
LIMIT  1000