How to Remove Provider Status Grouping in Revenue Report

[shuhaib_arkn]

dears,

@dchiesa1

I was trying to Integrate billing service in Drupal using Revenue Report. 

I am using Private Cloud Version of Apigee.

usually revenue reports gives response Group By DEVELOPER ,RATE PLAN , PACKAGE

So we will charge each row in (Sample)response Csv for billing,

But we have issue here we want charge the developers for each plan Not For each Provider Status,but the revenue report gives us response for each Provider Status, The response Contains Provider Status[OK,Not Found] and two rows is created for same developer and same plan only difference is the Provider Status,

is there any way to make the revenue or billing report which don't group by Provider Status?.

SAMPLE REQUEST:

--------------------------- 

Show More

curl --location --request POST 'http://<HOST>/v1/mint/organizations/org/revenue-reports' \

--header 'Accept: application/octet-stream' \

--header 'Authorization: <BASIC_AUTH>' \

--header 'Content-Type: application/json' \

--data-raw '{

    "fromDate": "2022-09-1",

    "toDate": "2022-10-1",

    "groupBy": [

        "DEVELOPER",

        "PACKAGE",

        "RATEPLAN"

    ],

    "transactionTypes": [

        "CHARGE"

    ],

    "devCustomAttributes": [

         "custom1",

         "custom2"

      ],

    "currencyOption": "LOCAL",

    "showSummary": true

}'

Sample Response :(What we got)

-------------------------

Show More

Reporting Period:,From:,2022-09-01, To:,2022-09-30
API Product:,All
Developer:,All
Application:,All
Currency:,Local
Type of Report:,Summary Revenue Report

Developer Name,Developer ID,Monetization Package,Package ID,Rate Plan,Plan ID,Currency,Transaction Type,Provider Status,Total Volume,Charged Rate,Developer Email,
ABC Bank,ABC-bank,TESTPLAN-v4,TESTPLAN-v4-xjrr,kh_freeplan,TESTPLAN-v4-xjrr_kh_freeplan,SAR,CHARGE,Not Found,12,,mof###ABC-bank@APIGEE-GEN.FOR-COMPANY,
ABC Bank,ABC-bank,TESTPLAN-v4,TESTPLAN-v4-xjrr,kh_freeplan,TESTPLAN-v4-xjrr_kh_freeplan,SAR,CHARGE,OK,6,,mof###ABC-bank@APIGEE-GEN.FOR-COMPANY

Expected revenue Response :(this one contain only one row for one plan and one developer and aggregated charge) but we could not figured out how it can be done in apigee

WHAT WE WANT:

---------------------------

Show More

Reporting Period:,From:,2022-09-01, To:,2022-09-30
API Product:,All
Developer:,All
Application:,All
Currency:,Local
Type of Report:,Summary Revenue Report

Developer Name,Developer ID,Monetization Package,Package ID,Rate Plan,Plan ID,Currency,Transaction Type,Provider Status,Total Volume,Charged Rate,Developer Email,
ABC Bank,ABC-bank,TESTPLAN-v4,TESTPLAN-v4-xjrr,kh_freeplan,TESTPLAN-v4-xjrr_kh_freeplan,SAR,CHARGE,,18,,mof###ABC-bank@APIGEE-GEN.FOR-COMPANY,

[jbodicherla]

Hi Shuhaib_arkn, another option for you is using custom variables. You can create reports using custom variable and populate custom variable based on business logic. This will help you to filter based on the value of custom variable.

[shuhaib_arkn]

Dear @jbodicherla ,
 Thank u for your quick response ,we Can not change Transaction Record Policy to Be Custom Variable since business will not allow us to do that immediately, since we are in prod ,we need to adapt to current Transaction Record Policy.  I hope someone can help in this