title: Magento2, how to display and get the custom table columns of sales_order table in rest API orders detail?
body: <p>I have fetched the order details thorugh rest api in magento2. Here is the below code:</p>
  <pre><code>&lt;?php
  ini_set('error_reporting', E_ALL);
  ini_set(&quot;display_errors&quot;, &quot;1&quot;);
  
  $userData = array(&quot;username&quot; =&gt; &quot;ADMIN_USERNAME&quot;, &quot;password&quot; =&gt; &quot;ADMIN_PASSWORD&quot;);
  $ch = curl_init(&quot;https://example.com/index.php/rest/V1/integration/admin/token&quot;);
  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, &quot;POST&quot;);
  curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($userData));
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array(&quot;Content-Type: application/json&quot;, &quot;Content-Lenght: &quot; . strlen(json_encode($userData))));
  
  echo $token = curl_exec($ch);
  
  $ch = curl_init(&quot;https://example.com/index.php/rest/V1/orders?searchCriteria=all&quot;);
  curl_setopt($ch, CURLOPT_CUSTOMREQUEST, &quot;GET&quot;);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($ch, CURLOPT_HTTPHEADER, array(&quot;Content-Type: application/json&quot;, &quot;Authorization: Bearer &quot; . json_decode($token)));
  
  $result = curl_exec($ch);
  
  //var_dump($result);
  
  $result = json_decode($result, 1);
  echo '&lt;pre&gt;';print_r($result);
  ?&gt;
  </code></pre>
  <p><strong>The output is in an array format. The default details are received but I have manually created 4 new columns from PHPMyAdmin (awb_no, prdt_type, prdt_code, client_code) in the sales_order table they are not present in the list see the screenshot: <a href="https://prnt.sc/tda4fb" rel="nofollow noreferrer">https://prnt.sc/tda4fb</a>. I have no idea how to call them in API.</strong></p>
  <p>I want the data of these 4 new columns in the rest API. Please help...</p>
  <p>Thanks in Advance,</p>