Load Data (Master and Analytic Models)
  • 1 Minute to read
  • Dark
    Light
  • PDF

Load Data (Master and Analytic Models)

  • Dark
    Light
  • PDF

Article summary

Use this API to import data to a Master or an Analytic model. Incremental data loads are supported. Invoke Clear Data API to clear all data in the model before the data import if an incremental data load is not needed. Use additional parameters to have a success or failure notification emailed to you.

Additional options described below include:

  • Optionally allowing data to continue to load even when dimension members are missing

  • Optionally adding missing dimension members

  • Optionally receiving notification upon success and failure of the data load

POST /modeling/model/data/load HTTP/1.1
Content-Type: application/xml
Accept: application/xml
X-ACCESS-TOKEN:
 
<?xml version="1.0" encoding="UTF-8"?>
<load-data-payload>
<model-name>$ModelName</model-name>
<delimiter>$Delimiter</delimiter>
<aggregate-flag>$AggregateFlag</aggregate-flag>
<continue-on-error>true</continue-on-error>
    <add-missing-dimension-members>true</add-missing-dimension-members>
    <missing-dimension-members>
    <entry>
        <key>dimensionname</key>
        <value>rollupname</value>
    </entry>
    </missing-dimension-members>     
<page-dimensions>
<entry>
<key>$PageDimension</key>
<value>$PageMember</value>
</entry>
	...
</page-dimensions>
<column-dimensions>
<entry>
<key>$ColumnNumber</key>
<value>$ColumnDimension</value>
</entry>
	...
</column-dimensions>
<column-members>
<entry>
<key>$ColumnNumber</key>
<value>$DimensionMember</value>
</entry>
	...
</column-members>
<notify-on-success>
<email>email1@domain</email>
<email>email2@domain</email>
</notify-on-success>
<notify-on-failure>
<email>email1@domain</email>
<email>email2@domain</email>
</notify-on-failure>
<data-records>
<data-record>$Data</data-record>
	...
</data-records>
</load-data-payload>

Was this article helpful?

What's Next