Search code examples
phpcurlgooddata

Fetch Report using GoodData API


I have created a report on my GoodData UI. Now I want to fetch this report using the API. I spent hours digging the API docs but I am unable to find a simple way to do so.

If I try gdc/execute/raw/, it returns

[error] => Array
    (
        [parameters] => Array
            (
                [0] => execute
            )

        [requestId] => 53fPgKcFdkjf8PZ5:4n6x9lp9vk3ydbvs
        [component] => GDC
        [errorClass] => GDC::Exception::NotFound
        [message] => resource %s not found
    )

If I try gdc/xtab2/executor3 it returns

[error] => Array
    (
        [parameters] => Array
            (
                [0] => report_req
                [1] => STRUCTURE INVALID - name of structure:'ReportReq'(tag:report_req),  /report_req/ExecutionObject: Object  does not match any alternative. Alternatives tried : [STRUCTURE INVALID - name of structure:'ReportReq' ...]
            )

        [requestId] => a0yRpNUpCPRsbPS0:6nagmwaw61h5g2bn
        [component] => Apache::REST
        [errorClass] => GDC::Exception::User
        [message] => Checking '%s', result %s
    )

Solution

  • Ultimately I followed this code piece https://gist.github.com/gnilrets/b9d2ce9890d8aaa07042

    Much better than reading the whole GoodData API documentation.