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

    Load Data (Master and Analytic Models)

    • Dark
    • 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>
    Shell

    Was this article helpful?