Example JSON Payloads

This document shows simplified example payloads produced when serializing POCO DataSet instances. The actual JSON may vary depending on configuration, but the general structure remains similar.

Example: Simple DataSet with One Table

{
 "Tables": {
  "Department": {
   "Columns": [
    { "Name": "Id", "DataType": "System.Int32", "IsNullable": false },
    { "Name": "Name", "DataType": "System.String", "IsNullable": false }
   ],
   "Rows": [
    { "Id": 1, "Name": "HR" },
    { "Id": 2, "Name": "IT" }
   ]
  }
 }
}

Example: DataSet with Request Metadata

{
 "Tables": {
  "RequestMetadata": {
   "Columns": [
    { "Name": "RequestId", "DataType": "System.Guid", "IsNullable": false },
    { "Name": "RequestType", "DataType": "System.String", "IsNullable": false }
   ],
   "Rows": [
    { "RequestId": "00000000-0000-0000-0000-000000000001", "RequestType": "EmployeeSearch" }
   ]
  },
  "Employee": {
   "Columns": [
    { "Name": "Id", "DataType": "System.Int32", "IsNullable": false },
    { "Name": "Name", "DataType": "System.String", "IsNullable": false }
   ],
   "Rows": [
    { "Id": 1, "Name": "John" }
   ]
  }
 }
}

Table of Content POCO DataSet Serialization and Deserialization