# MD for: https://www.mercadopago.com.uy/developers/es/docs/reports/sales-report/queries-and-validations.md

\# Queries and validations After creating the report, you can validate the structure and notifications by making a \*\*GET\*\* call to our API, following the instructions below. This applies to both types of reports. > To make GET requests to Structures, Notifier, Event, and Statement, it is necessary to include the \`TOKEN\` in the request header. Additionally, when making GET requests by ID to Structures, Notifier, Event, and Statement, it is mandatory to send the corresponding parameters: \`structure\_id\`, \`notifier\_id\`, \`event\_id\`, and \`statement\_id\`. ## GET Structures \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/structures' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json \[ { "id": {{structure\_id}}, "version": 0, "date\_created": "2023-07-19T19:34:33Z", "date\_last\_updated": "2023-07-19T19:34:33Z", "display\_timezone": "GMT-03", "name": "Structure marketplace", "file\_format": { "prefix": "marketplace", "column\_separator": ";", "decimal\_separator": "." }, "columns": \[ { "key": "COLLECTOR", "alias": "" }, { "key": "COLLECTOR\_NICKNAME", "alias": "" }, { "key": "PAYMENT", "alias": "" }, { "key": "STATUS\_DESCRIPTION", "alias": "" }, { "key": "STATUS\_DETAIL", "alias": "" }, { "key": "PURCHASE\_ORDER", "alias": "" }, { "key": "PAYMENT\_METHOD\_TYPE", "alias": "" }, { "key": "TRANSACTION\_AMOUNT", "alias": "" }, { "key": "DATE\_CREATED", "alias": "" }, { "key": "DATE\_APPROVED", "alias": "" }, { "key": "MARKETPLACE\_FEE\_AMOUNT", "alias": "" }, { "key": "MERCADOPAGO\_FEE\_AMOUNT", "alias": "" }, { "key": "TOTAL\_PAID\_AMOUNT", "alias": "" }, { "key": "NET\_RECEIVED\_AMOUNT", "alias": "" } \], "file\_config": null, "report\_translation": null, "include\_withdraw": null, "refund\_detailed": null, "show\_fee\_prevision": null, "coupon\_detailed": null, "show\_chargeback\_cancel": null }, { //more structures } \] \`\`\` ## GET Structure por ID \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/structures/:structure\_id' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json { "id": {{structure\_id}}, "version": 1, "date\_created": "2023-07-19T19:34:33Z", "date\_last\_updated": "2023-09-13T17:54:38Z", "display\_timezone": "GMT-03", "name": "Structure marketplace", "file\_format": { "prefix": "marketplace-op", "column\_separator": ";", "decimal\_separator": "." }, "columns": \[ { "key": "COLLECTOR", "alias": "" }, { "key": "COLLECTOR\_NICKNAME", "alias": "" }, { "key": "PAYMENT", "alias": "" }, { "key": "STATUS\_DESCRIPTION", "alias": "" }, { "key": "STATUS\_DETAIL", "alias": "" }, { "key": "PURCHASE\_ORDER", "alias": "" }, { "key": "PAYMENT\_METHOD\_TYPE", "alias": "" }, { "key": "TRANSACTION\_AMOUNT", "alias": "" }, { "key": "DATE\_CREATED", "alias": "" }, { "key": "DATE\_APPROVED", "alias": "" }, { "key": "MARKETPLACE\_FEE\_AMOUNT", "alias": "" }, { "key": "MERCADOPAGO\_FEE\_AMOUNT", "alias": "" }, { "key": "TOTAL\_PAID\_AMOUNT", "alias": "" }, { "key": "NET\_RECEIVED\_AMOUNT", "alias": "" } \], "file\_config": null, "report\_translation": null, "include\_withdraw": null, "refund\_detailed": null, "show\_fee\_prevision": null, "coupon\_detailed": null, "show\_chargeback\_cancel": null } \`\`\` ## GET Notifiers \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/notifiers' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json \[ { "id": {{notifier\_id}}, "type": "email", "data": { "recipients": \[ "test@mercadolibre.com" \] }, "description": null, "version": 0, "status": "ACTIVE", "is\_pii\_data": true }, { ... // more responses } \] \`\`\` ## GET Notifier por ID \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/notifiers/:notifier:id' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json { "id": {{notifier\_id}}, "type": "email", "data": { "recipients": \[ "test@mercadolibre.com" \] }, "description": null, "version": 0, "status": "ACTIVE", "is\_pii\_data": true } \`\`\` ## GET Events \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/events' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json \[ { "id": {{event\_id}}, "type": "frequency", "data": { "period": "daily", "value": 1, "hour": 20, "skip\_non\_working\_days": false }, "description": "Mail diario a las 20:00", "structure\_id": {{structure\_id}}, "notifiers": \[ {{notifier\_id}} \], "status": "ACTIVE", "version": 1 }, { ... // more responses } \] \`\`\` ## GET Event por ID \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/events/:event\_id' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json { "id": {{event\_id}}, "type": "frequency", "data": { "period": "daily", "value": 0, "hour": 11, "skip\_non\_working\_days": false }, "description": "Evento para envío los viernes ", "structure\_id": {{structure\_id}}, "notifiers": \[ {{notifier\_id}} \], "status": "ACTIVE", "version": 1, "user\_id": {{user\_id}} } \`\`\` ## GET Statements \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/statements' \\ --header 'Content-Type: application/json' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json { "id": {{statement\_id}}, "date\_start": "2023-07-18T00:00:00Z", "date\_end": "2023-07-20T19:00:00Z", "date\_created": "2023-07-21T17:25:25.764122Z", "created\_by": "automatic", "description": "statement de pruebas", "report": { "id": "marketplace\_sellers\_sales", "name": "Marketplace OP", "topic": "financial\_statements", "version": "1" }, "files": \[ { "type": "json", "url": "https://api.mercadopago.com/v1/reporting/reports/marketplace\_sellers\_sales/statements/{{statement\_id}}/download?format=json" }, { "type": "csv", "url": "https://api.mercadopago.com/v1/reporting/reports/marketplace\_sellers\_sales/statements/{{statement\_id}}/download?format=csv" } \], "event": null, "origin": { "type": "date\_range", "data": { "date\_end": "2023-07-20T19:00:00Z", "date\_start": "2023-07-18T00:00:00Z" } }, "report\_extra\_data": {}, "structure": { "id": {{structure\_id}}, "version": 0 }, "notifiers": \[ { "id": {{notifier\_id\_1}}, "version": 0, "type": "email", "data": {} }, { "id": {{notifier\_id\_n}}, "version": 0, "type": "ftp", "data": {} } \], "status": "available", "reason\_code": { "code": "" } } \`\`\` ## GET Statement por ID \`\`\`curl curl --location --request GET 'https://api.mercadopago.com/v1/reports/marketplace\_sellers\_sales/statements/:statement\_id' \\ --header 'Content-Type: application/json' \\ --header 'Authorization: Bearer {{TOKEN}}' \`\`\` #### Response \`\`\`json { "id": {{statement\_id}}, "date\_start": "2023-07-18T00:00:00Z", "date\_end": "2023-07-20T19:00:00Z", "date\_created": "2023-07-21T17:25:25.764122Z", "created\_by": "automatic", "description": "statement de pruebas", "report": { "id": "marketplace\_sellers\_sales", "name": "Marketplace OP", "topic": "financial\_statements", "version": "1" }, "files": \[ { "type": "json", "url": "https://api.mercadopago.com/v1/reporting/reports/marketplace\_sellers\_sales/statements/{{statement\_id}}/download?format=json" }, { "type": "csv", "url": "https://api.mercadopago.com/v1/reporting/reports/marketplace\_sellers\_sales/statements/{{statement\_id}}/download?format=csv" } \], "event": null, "origin": { "type": "date\_range", "data": { "date\_end": "2023-07-20T19:00:00Z", "date\_start": "2023-07-18T00:00:00Z" } }, "report\_extra\_data": {}, "structure": { "id": {{structure\_id}}, "version": 0 }, "notifiers": \[ { "id": {{notifier\_id\_1}}, "version": 0, "type": "email", "data": {} }, { "id": {{notifier\_id\_n}}, "version": 0, "type": "ftp", "data": {} } \], "status": "available", "reason\_code": { "code": "" } } \`\`\`