Using REST API to fetch data from SFMC Data View

Question

I have seen various answers by Lukas Lunow (Is there any way of retrieving all records from a data extension via REST API for Marketing Cloud?) and Gortonington on the usage of undocumented REST API to fetch data from a DE.

Is there any similar option to fetch data from a Data View (e.g. _Subscribers, _SMSMEssageTRacking, etc.) using query parameters for filter and pagination which work well for DEs? Can the same APIs be used and how do we obtain the ID or Key for a DataView?

I am referring to these 2 APIs

   "getCustomObjectDataById": {
        "path": "customobjectdata/{id}/rowset",
        "httpMethod": "get",
        "description": "Retrieves Data Extension data from Custom Object looked up by id",
        "parameters": {}
    },
    "getCustomObjectDataByKey": {
        "path": "customobjectdata/key/{key}/rowset",
        "httpMethod": "get",
        "description": "Retrieves Data Extension data from Custom Object looked up by key",
        "parameters": {}
    },

Answer 1

No, you cannot access the DataViews from REST API (at least not that I have found so far).

You can though hit the SOAP Objects which hold very similar (almost identical) data.

• BounceEvent
• ClickEvent
• SentEvent
• OpenEvent
• Automation
• AutomationInstance
• ...etc

You can use these SOAP objects to do what you are looking to do with Pagination, filtering, etc. Some of these objects do have limitations on filtering and what can be retrieved though, so you may want to research the capabilities of each before attempting the call.

Zuzanna has a great article that you can use as a starting point for this.