function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mike SheehanMike Sheehan 

Reporting API Grouping

Does anyone know if there is any plans or way to modify the 'Grouping' fields on a report when retrieved via the Reporting API?  i.e. with the Reporting API you can dynamically specify custom filters when requesting report data via POST by providing the 'reportFilters' JSON data with the request.  It would be awesome if you could also provide custom 'GroupingDown' or 'GroupingAcross' fields or sort orders etc with the request.  Any way to know if this is a feature that may one day be available?
HawkedHawked

When you post the JSON can you not include the Groupingsdown/Groupingsacross? From the docs I see a sample request can be as below 
  
{
    "reportMetadata": {
        "name": "FilterAcctsReport",
        "id": "00OD0000001cw27MAA",
        "reportFormat": "SUMMARY",
        "reportBooleanFilter": "(1OR4)AND2AND3",
        "reportFilters": [
            {
                "value": "DataMart",
                "operator": "notEqual",
                "column": "ACCOUNT.NAME"
            },
            {
                "value": "AdminUser",
                "operator": "notEqual",
                "column": "USERS.NAME"
            },
            {
                "value": "\"100,000\"",
                "operator": "greaterThan",
                "column": "SALES"
            },
            {
                "value": "Manufacturing,Recreation",
                "operator": "notEqual",
                "column": "INDUSTRY"
            }
        ],
        "detailColumns": [
            "RATING",
            "LAST_UPDATE",
            "SALES"
        ],
        "developerName": "Filter_Accts_Report",
        "reportType": {
            "type": "AccountList",
            "label": "Accounts"
        },
        "currency": null,
        "aggregates": [
            "s!SALES",
            "RowCount"
        ],
        "groupingsDown": [
            {
                "name": "USERS.NAME",
                "sortAggregate": "s!SALES",
                "sortOrder": "Desc",
                "dateGranularity": "None"
            },
            {
                "name": "ACCOUNT.NAME",
                "sortAggregate": null,
                "sortOrder": "Asc",
                "dateGranularity": "None"
            },
            {
                "name": "DUE_DATE",
                "sortAggregate": null,
                "sortOrder": "Asc",
                "dateGranularity": "Month"
            }
        ],
        "groupingsAcross": []
    }
}



http://www.salesforce.com/us/developer/docs/api_analytics/
Mike SheehanMike Sheehan
Thanks for the response. I have tried including this data in the POST as shown in the docs, but it doesn’t seem to do anything – the data comes back with the original report groupings regardless of what I put in the POST request. So it seems like it isn’t monitoring this data unless I am missing something.