Saturday 1 August 2015

SAPNTGW - GET_ENTITYSET Test Response

{
  "d" : {
    "results" : [
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='001')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='001')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000001",
        "DepNo" : "001",
        "DepType" : "0001",
        "DependentName" : "Dependent1"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='002')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='002')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000001",
        "DepNo" : "002",
        "DepType" : "0001",
        "DependentName" : "Dependent2"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='004')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000001',DepNo='004')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000001",
        "DepNo" : "004",
        "DepType" : "0001",
        "DependentName" : "Dependent3"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000002',DepNo='003')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000002',DepNo='003')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000002",
        "DepNo" : "003",
        "DepType" : "0001",
        "DependentName" : "Dependent1"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000002',DepNo='004')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000002',DepNo='004')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000002",
        "DepNo" : "004",
        "DepType" : "0001",
        "DependentName" : "Dependent2"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000007',DepNo='003')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000007',DepNo='003')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000007",
        "DepNo" : "003",
        "DepType" : "0001",
        "DependentName" : "Dependent1"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000007',DepNo='004')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000007',DepNo='004')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000007",
        "DepNo" : "004",
        "DepType" : "0001",
        "DependentName" : "Dependent2"
      },
      {
        "__metadata" : {
          "id" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000009',DepNo='001')",
          "uri" : "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Dependent_DataSet(Employee='00000009',DepNo='001')",
          "type" : "ZMA_EMPS_SRV.Dependent_Data"
        },
        "Employee" : "00000009",
        "DepNo" : "001",
        "DepType" : "0001",
        "DependentName" : "Dependent1"
      }
    ]
  }
}


SAPNTGW - SELECT Test Response

- <feed xmlns="http://www.w3.org/2005/Atom"xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xml:base="http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/">
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet</id>
  <title type="text">Emp_DataSet</title>
  <updated>2015-12-09T13:31:16Z</updated>
- <author>
  <name />
  </author>
  <link href="Emp_DataSet" rel="self" title="Emp_DataSet" />
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000001')</id>
  <title type="text">Emp_DataSet('00000001')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000001')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000001</d:Employee>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000002')</id>
  <title type="text">Emp_DataSet('00000002')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000002')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000002</d:Employee>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000003')</id>
  <title type="text">Emp_DataSet('00000003')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000003')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000003</d:Employee>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000007')</id>
  <title type="text">Emp_DataSet('00000007')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000007')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000007</d:Employee>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000008')</id>
  <title type="text">Emp_DataSet('00000008')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000008')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000008</d:Employee>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000009')</id>
  <title type="text">Emp_DataSet('00000009')</title>
  <updated>2015-12-09T13:31:16Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000009')" rel="self" title="Emp_Data" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000009</d:Employee>
  </m:properties>
  </content>
  </entry>
  </feed>

SAPNTGW - ORDERBY_DESC_JSON Test Response

{
  
"d" : {
    
"results" : [
      {
        
"__metadata" : {
          
"id" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000007')",
          
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000007')",
          
"type" "ZMA_EMPS_SRV.Emp_Data"
        },
        
"Employee" "00000007",
        
"EmployeeName" "Employee4",
        
"Dependent_Dataset" : {
          
"__deferred" : {
            
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000007')/Dependent_Dataset"
          }
        }
      },
      {
        
"__metadata" : {
          
"id" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000003')",
          
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000003')",
          
"type" "ZMA_EMPS_SRV.Emp_Data"
        },
        
"Employee" "00000003",
        
"EmployeeName" "Employee3",
        
"Dependent_Dataset" : {
          
"__deferred" : {
            
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000003')/Dependent_Dataset"
          }
        }
      },
      {
        
"__metadata" : {
          
"id" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000002')",
          
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000002')",
          
"type" "ZMA_EMPS_SRV.Emp_Data"
        },
        
"Employee" "00000002",
        
"EmployeeName" "Employee2",
        
"Dependent_Dataset" : {
          
"__deferred" : {
            
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000002')/Dependent_Dataset"
          }
        }
      },
      {
        
"__metadata" : {
          
"id" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000001')",
          
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000001')",
          
"type" "ZMA_EMPS_SRV.Emp_Data"
        },
        
"Employee" "00000001",
        
"EmployeeName" "Employee1",
        
"Dependent_Dataset" : {
          
"__deferred" : {
            
"uri" "http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000001')/Dependent_Dataset"
          }
        }
      }
    ]
  }
}

SAPNTGW - FILTER_MULTIPLE_KEYS Test Response

- <feed xmlns="http://www.w3.org/2005/Atom"xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xml:base="http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/">
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet</id>
  <title type="text">Emp_DataSet</title>
  <updated>2015-12-09T13:25:23Z</updated>
- <author>
  <name />
  </author>
  <link href="Emp_DataSet" rel="self" title="Emp_DataSet" />
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000001')</id>
  <title type="text">Emp_DataSet('00000001')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000001')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000001')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000001</d:Employee>
  <d:EmployeeName>Employee1</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000002')</id>
  <title type="text">Emp_DataSet('00000002')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000002')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000002')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000002</d:Employee>
  <d:EmployeeName>Employee2</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000003')</id>
  <title type="text">Emp_DataSet('00000003')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000003')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000003')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000003</d:Employee>
  <d:EmployeeName>Employee3</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000007')</id>
  <title type="text">Emp_DataSet('00000007')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000007')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000007')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000007</d:Employee>
  <d:EmployeeName>Employee4</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000008')</id>
  <title type="text">Emp_DataSet('00000008')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000008')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000008')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000008</d:Employee>
  <d:EmployeeName>Employee8</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
- <entry>
  <id>http://devdgw-ci.sap.umb.vqss.com:8001/sap/opu/odata/sap/ZMA_EMPS_SRV/Emp_DataSet('00000009')</id>
  <title type="text">Emp_DataSet('00000009')</title>
  <updated>2015-12-09T13:25:23Z</updated>
  <category term="ZMA_EMPS_SRV.Emp_Data" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link href="Emp_DataSet('00000009')" rel="self" title="Emp_Data" />
  <link href="Emp_DataSet('00000009')/Dependent_Dataset" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Dependent_Dataset" type="application/atom+xml;type=feed" title="Dependent_Dataset" />
- <content type="application/xml">
- <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
  <d:Employee>00000009</d:Employee>
  <d:EmployeeName>Mahe</d:EmployeeName>
  </m:properties>
  </content>
  </entry>
  </feed>