Solved: Monetization Transactions showing in summary and n... - Page 2

chawkimatta · 09-23-2019 03:04 AM

The Summary Revenue Report is showing a row of transaction type "CHARGE" with the total volume and charge rate as shown below:

but the transactions are not showing in the Detailed Revenue Report:

any one faced this issue?
aren't we supposed to get all the successful requests in the detailed report?

kurtkanaskie

Ah, OK, to see the actual transactions and dates, you can use the Management API for "transaction-search". The response includes a lot of meta data, so you will need to filter the results, as I've shown using JQ.

You can eliminate the "devCriteria" and get results for all developers, just wanted to show it as an example.

curl -n -X POST \
  'https://api.enterprise.apigee.com/v1/mint/organizations/{{ORG}}/transaction-search?size=100' \
  -H 'Content-Type: application/json' \
  -d '{
	"billingMonth": "AUGUST",
	"billingYear": 2019,
	"devCriteria": [{
		"id": "{{devId}}",
		"orgId": "{{ORG}}"
	}],
	"transactionTypes": [
	    "PURCHASE",
            "CHARGE",
            "REFUND",
            "CREDIT"
	]
}' > results.json

Then using JQ:

$ cat results.json | jq '.transaction[] | 
{
    type: .type, 
    rate: .rate, 
    startTime:.startTime, 
    ratePlan_displayName:.ratePlan.displayName,
    developer_email:.developer.email,
    product_id:.product.id,
    application_name:.application.name
}'

...
{
  "type": "CHARGE",
  "rate": 0.05,
  "startTime": "2019-08-09 15:39:26",
  "ratePlan_displayName": "pingstatus-all-starter",
  "developer_email": "developer+app@any.com",
  "product_id": "pingstatus-v2-product-prod",
  "application_name": "kurt-app-prepaid"
}
...

View solution in original post

Monetization Transactions showing in summary and not in Detailed report