title: Importing Data GI In web service
body: <p>I have a requirement to import custom data into Acumatica using web service using web service.</p>
  
  <p>I have created a custom table having 2 string field and one ntext field which will hold XML data.
  Created a GI for it and exposed in web service endpoint.</p>
  
  <p>The import JSON Data format is like this.</p>
  
  <pre><code>    [
    {
      "OrderNbr": "1",
      "CommandValue": "8",
      "Xmldata": "&lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;&lt;MLW Cmd=\"8\" TStamp=\"2018-12-21T11:38:25\" Id=\"dsgx1\" OrgId=\"157035408\" DevId=\"b9d863ca-REG-4825e4aa-566b5fc7\" RouteId=\"Resource-879-1\" StopId=\"Location230\" LocationKey=\"Location230\" StopType=\"67\"&gt; &lt;GPS Altitude=\"278.46383285522461\" Latitude=\"34.0487467032243\" Longitude=\"-84.673757432107507\" NoOfSat=\"7\" Speed=\"1.3679999828338623\" SatTStamp=\"2018-12-21T11:37:26\" Direction=\"0\" FixQuality=\"A\" /&gt; &lt;FieldData LCode=\"1\" OwnerId=\"Location230\"&gt; &lt;Field FId=\"89815\" Value=\"No\" /&gt; &lt;Field FId=\"89817\" Value=\"No\" /&gt; &lt;Field FId=\"89816\" Value=\"Patrick N\" /&gt; &lt;/FieldData&gt; &lt;Job Id=\"Order-878-4\" Status=\"4\"&gt; &lt;Item Status=\"4\" Id=\"TIFTUF\" Mode=\"Manual\" /&gt; &lt;/Job&gt;&lt;/MLW&gt;"
    }
  ]
  </code></pre>
  
  <p>I have tried in POSTMAN using basic authentication.</p>
  
  <p>I am getting following error</p>
  
  <p>PUT: 400 Bad request
  GET: 500 Internal server error.</p>
  
  <p><strong>UPDATE</strong>:  I have created a custom list page and configured it in the endpoint.</p>
  
  <p>I have tested in POSTMAN and</p>
  
  <p>Following are the endpoint and the JSON string used to create records</p>
  
  <pre><code>http://localhost/XYZ/(W(3))/entity/XYZ/17.200.001.001/MyResposeImport
  
  
  
  {
      "OrderNbr": {value :"b"},
      "CommandValue": {value :"8"},
      "Xmldata": {value :"&lt;?xml version='1.0' encoding='utf-8'?&gt;&lt;MLW Cmd='8' TStamp='2018-12-21T11:38:25' Id='dsgx1' OrgId='157035408' DevId='b9d863ca-REG-4825e4aa-566b5fc7' RouteId='Resource-879-1' StopId='Location230' LocationKey='Location230' StopType='67'&gt; &lt;GPS Altitude='278.46383285522461' Latitude='34.0487467032243' Longitude='-84.673757432107507' NoOfSat='7' Speed='1.3679999828338623' SatTStamp='2018-12-21T11:37:26' Direction='0' FixQuality='A' /&gt; &lt;FieldData LCode='1' OwnerId='Location230'&gt; &lt;Field FId='89815' Value='No' /&gt; &lt;Field FId='89817' Value='No' /&gt; &lt;Field FId='89816' Value='Patrick N' /&gt; &lt;/FieldData&gt; &lt;Job Id='Order-878-4' Status='4'&gt; &lt;Item Status='4' Id='TIFTUF' Mode='Manual' /&gt; &lt;/Job&gt;&lt;/MLW&gt;"}
    }
  </code></pre>
  
  <p>PUT Returns back OK and the response give below</p>
  
  <pre><code>{
      "id": "94a00013-37bf-4077-bfb6-2e8662988547",
      "rowNumber": 1,
      "note": null,
      "OrderNbr": {
          "value": "b"
      },
      "ShippingStatus": {},
      "XMLData": {},
      "custom": {},
      "files": []
  }
  </code></pre>
  
  <p>I have checked in the back end and no record added to the table.</p>
  
  <p>I have created the sitemap under the hidden section since the screen is only API call. </p>
  
  <p>What may be the reason for the record not added to the table?</p>