> ## 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.

# insert_records_json

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.insert_records_json"> <span className="sig-name descname"><span className="pre">insert\_records\_json</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">json\_records</span></span></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">json\_options</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">create\_table\_options</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">options</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#L10943"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Inserts a single JSON record or an array of JSON records passed in as a string.</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">json\_records (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>Either a single JSON record or an array of JSON records (as string). Mandatory.</p>
            </div>

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

            <div className="dd">
              <p>The name of the table to insert into.</p>
            </div>

            <div className="dt">json\_options (<span className="em">dict</span>) –</div>

            <div className="dd">
              <p>Map of options–only valid one is <span className="em">validate</span>, which determines whether JSON validation is performed on all records before inserting</p>
            </div>

            <div className="dt">create\_table\_options (<span className="em">dict</span>) –</div>

            <div className="dd">
              <p>Same options as the <span className="em">create\_table\_options</span> in the <a className="reference internal" href="#gpudb.GPUdb.insert_records_from_payload" title="gpudb.GPUdb.insert_records_from_payload"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.insert\_records\_from\_payload()</span></code></a> endpoint</p>
            </div>

            <div className="dt">options (<span className="em">dict</span>) –</div>

            <div className="dd">
              <p>Same options as <span className="em">options</span> in the <a className="reference internal" href="#gpudb.GPUdb.insert_records_from_payload" title="gpudb.GPUdb.insert_records_from_payload"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.insert\_records\_from\_payload()</span></code></a> endpoint</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>
          ```
          response = gpudb.insert_records_json(records, "test_insert_records_json", json_options={'validate': True}, create_table_options={'truncate_table': 'true'})
          response_object = json.loads(response)
          print(response_object['data']['count_inserted'])
          ```
        </div>
      </div>

      <div className="admonition seealso">
        <p className="admonition-title">See also</p>
        <p><a className="reference internal" href="#gpudb.GPUdb.insert_records_from_payload" title="gpudb.GPUdb.insert_records_from_payload"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.insert\_records\_from\_payload()</span></code></a></p>
      </div>
    </div>
  </div>
</div>