> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# get_records_json

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.get_records_json"> <span className="sig-name descname"><span className="pre">get\_records\_json</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">table\_name</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">column\_names</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">offset</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">0</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">limit</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">-9999</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">expression</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">orderby\_columns</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">having\_clause</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span><span className="sig-paren">)</span><a href="https://github.com/kineticadb/kinetica-api-python/blob/master/gpudb/gpudb.py#L11010"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Retrieves records from a table in the form of a JSON array (stringified). The only mandatory parameter is the ‘tableName’. The rest are all optional with suitable defaults wherever applicable.</p>
      <p>If a fail-over event is triggered, this function will handle failing over to a secondary cluster.</p>
      <p><strong>Parameters</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl simple">
            <div className="dt">table\_name (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>Name of the table to query</p>
            </div>

            <div className="dt">column\_names (<span className="em">list</span>) –</div>

            <div className="dd">
              <p>the columns names to retrieve, or None for all</p>
            </div>

            <div className="dt">offset (<span className="em">int</span>) –</div>

            <div className="dd">
              <p>the offset to start from; default 0</p>
            </div>

            <div className="dt">limit (<span className="em">int</span>) –</div>

            <div className="dd">
              <p>the maximum number of records; default GPUdb.END\_OF\_SET</p>
            </div>

            <div className="dt">expression (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>the filter expression</p>
            </div>

            <div className="dt">orderby\_columns (<span className="em">list</span>) –</div>

            <div className="dd">
              <p>the list of columns to order by</p>
            </div>

            <div className="dt">having\_clause (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>the having clause</p>
            </div>
          </div>
        </div>
      </div>

      <p><strong>Returns</strong></p>

      <div className="blockquote">
        <div>
          <p>The response string (<span className="em">JSON</span>)</p>
        </div>
      </div>

      <p><strong>Raises</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl simple">
            <div className="dt">GPUdbException –</div>

            <div className="dd">
              <p>On detecting invalid parameters or some other internal errors</p>
            </div>
          </div>
        </div>
      </div>

      <p>Example</p>

      <div className="highlight-default notranslate">
        <div>
          ```
          resp = gpudb.get_records_json("table_name")
          json_object = json.loads(resp)
          print(json_object["data"]["records"])
          ```
        </div>
      </div>
    </div>
  </div>
</div>