Retrieving extended CSV data from Google Checkout's Order Report API

Question

The Google Checkout orders page allows you to download the orders data as CSV. There is a checkbox that allows you to specify that the CSV should include extra data (buyer's name and address, product details).

The Google Checkout Order Report API provides a way to get CSV order data programmatically. However, it doesn't seem to be possible to get the data in the extended format. Am I missing something? Is there some way to specify that you want the full data?

The default data is pretty uninformative.

Answer 1

Well it's not documented, but after a bit of sniffing around and experimenting I discovered that the <order-list-request> API method accepts another nested parameter tag, <column-style>, and that this should be set to EXPANDED.

So a request for the full CSV looks like this:

<order-list-request xmlns="http://checkout.google.com/schema/2"
                    start-date="2010-08-01T00:00:00"
                    end-date="2010-08-31T23:59:59">
  <date-time-zone>Europe/London</date-time-zone>
  <column-style>EXPANDED</column-style>
</order-list-request>