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 about 2 years 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 about 2 years 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 about 2 years 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