REST API for reading from a Data Extension

Question

The REST API documentation doesn't have any method to read from a data extension while it has a couple of writing into it.

So is SOAP is the only API to read from a DE?

Answer 1

It's not documented save for a call to GET https://www.exacttargetapis.com/data/v1/rest, but GET https://www.exacttargetapis.com/data/v1/customobjectdata/key/[DE CustomerKey]/rowset/ will do exactly what you want, and it's not limited to data extensions linked to the contact model.

I've also found it will accept at least the same query string parameters as the ContentBuilder simple asset query plus $top. You can build more complex filters with AND, OR, and parentheses. Property IS [NOT] NULL works too.

Answer 2

Probably best bet is something like https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/fetchAttributes.htm which allows you to go through DEs with are in the contact model.

For example:

Host: https://www.exacttargetapis.com
POST /contacts/v1/attributes/search 
Content-Type: application/json
Authorization: Bearer YOUR_ACCESS_TOKEN

{
    "request": {
        "attributes": [{
                "key": "MobileConnect Demographics.First Name"
            },
            {
                "key": "MobileConnect Demographics.Last Name"
            },
            {
                "key": "Retail Orders.Order Number"
            },
            {
                "key": "Retail Orders.Order Total"
            }]

    },
    "conditionSet": {
        "operator": "And",
        "conditionSets": [],
        "conditions": [{
            "attribute": {
                "key": "Retail Orders.Order Total"
            },
            "operator": "GreaterThan",
            "value": {
                "items": ["1,000.00"]
            }
        }]
    }
}