Counting records via notification policy and API : Portal

Start a new topic

Answered

Counting records via notification policy and API

Subham Dixit

started a topic over 1 year ago

Is there any way of getting a reliable count of the actual golden records inserted/updated by a load in

a) a Notification policy

b) through the API (count records from a named query, not from a single entity) ?

Best Answer

Subham Dixit said over 1 year ago

For notifications, the volume by transaction types (available in notification properties) are calculated for all steps of integration jobs. So it doesn't match your requirement.

For REST API, I think you can try to use these expressions based on standard API:

Get Count of GD Creation : <baseurl>/api/rest/count/<datalocation>/<entity>/GD?$f=BatchID=<batch_id> and UpdateDate=CreationDate

Get Count of GD Update : <baseurl>/api/rest/count/<datalocation>/<entity>/GD?$f=BatchID=<batch_id> and UpdateDate>CreationDate

1 Comment

Subham Dixit

said over 1 year ago

Answer

For notifications, the volume by transaction types (available in notification properties) are calculated for all steps of integration jobs. So it doesn't match your requirement.

For REST API, I think you can try to use these expressions based on standard API:

Get Count of GD Creation : <baseurl>/api/rest/count/<datalocation>/<entity>/GD?$f=BatchID=<batch_id> and UpdateDate=CreationDate

Get Count of GD Update : <baseurl>/api/rest/count/<datalocation>/<entity>/GD?$f=BatchID=<batch_id> and UpdateDate>CreationDate