Xero · Example Payload

Xero Getreportexecutivesummary Example

AccountingBank FeedsFinanceFinancial ServicesInvoicingPayrollSmall Business

Xero Getreportexecutivesummary Example is an example object payload from Xero, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

operationIdmethodpathsummaryrequestExamplesresponseExamples

Example Payload

Raw ↑
{
  "operationId": "getReportExecutiveSummary",
  "method": "GET",
  "path": "/Reports/ExecutiveSummary",
  "summary": "Xero Retrieves report for executive summary",
  "requestExamples": [],
  "responseExamples": [
    {
      "status": "200",
      "contentType": "application/json",
      "example": {
        "Id": "068d3505-ac37-43f3-8135-f912a5963d8a",
        "Status": "OK",
        "ProviderName": "provider-name",
        "DateTimeUTC": "/Date(1573755038314)/",
        "Reports": [
          {
            "ReportName": "Executive Summary",
            "ReportType": "ExecutiveSummary",
            "ReportTitles": [
              "Executive Summary",
              "Online Test 11",
              "For the month of November 2019"
            ],
            "ReportDate": "14 November 2019",
            "UpdatedDateUTC": "/Date(1573755038314)/",
            "Fields": [],
            "Rows": [
              {
                "RowType": "Header",
                "Cells": [
                  {
                    "Value": ""
                  },
                  {
                    "Value": "Nov 2019"
                  },
                  {
                    "Value": "Oct 2019"
                  },
                  {
                    "Value": "Variance"
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Cash",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Cash received"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Cash spent"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Cash surplus (deficit)"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Closing bank balance"
                      },
                      {
                        "Value": "79.01"
                      },
                      {
                        "Value": "79.01"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Profitability",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Income"
                      },
                      {
                        "Value": "40.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Direct costs"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Gross profit (loss)"
                      },
                      {
                        "Value": "40.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Other Income"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Expenses"
                      },
                      {
                        "Value": "205.40"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Profit (loss)"
                      },
                      {
                        "Value": "-165.40"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Balance Sheet",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Debtors"
                      },
                      {
                        "Value": "590.00"
                      },
                      {
                        "Value": "550.00"
                      },
                      {
                        "Value": "7.3%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Creditors"
                      },
                      {
                        "Value": "-44.00"
                      },
                      {
                        "Value": "-44.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Net assets"
                      },
                      {
                        "Value": "594.16"
                      },
                      {
                        "Value": "759.56"
                      },
                      {
                        "Value": "-21.8%"
                      }
                    ]
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Income",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Number of invoices issued"
                      },
                      {
                        "Value": "1"
                      },
                      {
                        "Value": "0"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Average value of invoices"
                      },
                      {
                        "Value": "40.00"
                      },
                      {
                        "Value": "0.00"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Performance",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Gross profit margin"
                      },
                      {
                        "Value": "100.0%"
                      },
                      {
                        "Value": ""
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Net profit margin"
                      },
                      {
                        "Value": "-413.5%"
                      },
                      {
                        "Value": ""
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Return on investment (p.a.)"
                      },
                      {
                        "Value": "-334.1%"
                      },
                      {
                        "Value": "0.0%"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  }
                ]
              },
              {
                "RowType": "Section",
                "Title": "Position",
                "Rows": [
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Average debtors days"
                      },
                      {
                        "Value": "442.50"
                      },
                      {
                        "Value": "0"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Average creditors days"
                      },
                      {
                        "Value": "-6.426484907497565725413826680"
                      },
                      {
                        "Value": "0"
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Short term cash forecast"
                      },
                      {
                        "Value": "634.00"
                      },
                      {
                        "Value": "594.00"
                      },
                      {
                        "Value": "6.7%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Current assets to liabilities"
                      },
                      {
                        "Value": "4.0729764675459012154124644427"
                      },
                      {
                        "Value": "-62.034024896265560165975103734"
                      },
                      {
                        "Value": "106.6%"
                      }
                    ]
                  },
                  {
                    "RowType": "Row",
                    "Cells": [
                      {
                        "Value": "Term assets to liabilities"
                      },
                      {
                        "Value": ""
                      },
                      {
                        "Value": ""
                      },
                      {
                        "Value": "0.0%"
                      }
                    ]
                  }
                ]
              }
            ]
          }
        ]
      }
    }
  ]
}