If you are unable to connect to the API, please contact support. We love to provide support, however, support for using an API is too technical for our support team (unless you have a Premium Support contract). For all other matters related to the API, your company is expected to have the expertise to proceed without requesting support. We are unable to tell you how to use the data, how to filter it, or how to write SQL or build reports from it, we will not write your SQL, we are unable to change the filtering of the data (once again, you can do this youself using whatever tool you have chosen). The data is provided in a flat file XML format, with the associations between data logical and determined by using the "Data Definition" document. It is assumed a company capable of using an API is capable of understanding and massaging the data without assitance.