importConfigurableModelData

要求格式

<?xml version='1.0' encoding='UTF-8'?>
<call method="importConfigurableModelData" callerName="a string that identifies your client application">
<credentials login="sampleuser@company.com" password="my_pwd" instanceCode="INSTANCE1"/>
<importDataOptions planOrActuals="Plan" allowParallel="false" moveBPtr="false" useMappings="false" replaceExisting="2"/>
<version name="Budget 2014" isDefault="false" />
<sheet name="Personnel" isUserAssigned="false" />
<rowData>
 <header>Level|Region|Title|JobCode|Benefits|per|Last Name|First Name|ID|Start|End|Hr/Week|Pay Rate|Pay Rate Display Column</header>
 <rows>
   <row>Corporate Plan|Any|CEO|E1|Yes|Yr|Topdog|Andy|1000|12/20/2013|12/30/2014|80|500,000.12|888,888</row>
 </rows>
</rowData>
</call>

使用 importKey 更新現有列的要求格式

<?xml version='1.0' encoding='UTF-8'?>
<call method="importConfigurableModelData" callerName="a string that identifies your client application">
<credentials login="sampleuser@company.com" password="my_pwd"instanceCode="INSTANCE1"/>
<importDataOptions planOrActuals="Plan" replaceExisting="3" importKey="Region" allowParallel="false" moveBPtr="false" useMappings="false"/>
<version name="Budget 2014" isDefault="false" />
<sheet name="Personnel" isUserAssigned="false" />
<rowData>
 <header>Plan|Region|Benefits|per</header>
 <rows>
   <row>Europe Sales|W-US|Yes|Hr</row>
 </rows>
</rowData>
</call>

回覆格式

成功範例

<?xml version='1.0' encoding='UTF-8'?>
<response success="true">
<messages>
 <message key="modeled-import-success">Personnel import successful. Rows imported: 1</message>
 <message key="modeled-import-replace">All existing rows were replaced.</message>
</messages>
</response>

失敗 (使用環境定義)

<?xml version='1.0' encoding='UTF-8'?>
<response success="false">
 <messages>
     <message key="modeled-import-failed">The Personnel import has failed.</message>
     <message key="error-import">Import Failed with the following error: 1 Error(s) Occurred.</message>
     <message key="import-detail">Additional information:</message>
     <message key="warning-nonexistent-dimension-value">Warning: No data was imported for rows with the following dimension values because the dimension values for Plan do not exist: Development1.</message>
     <message key="invalid-plan-choice-withCoordinate">
         <context>
             <col header="Plan" value="Development1" />
             <col header="Region" value="C-US" />
             <col header="Title" value="CEO" />
             <col header="JobCode" value="E1" />
             <col header="Benefits" value="Yes" />
             <col header="per" value="Yr" />
             <col header="Last Name" value="Topdog" />
             <col header="First Name" value="Andy" />
             <col header="ID" value="1000" />
             <col header="Start" value="12/20/2013" />
             <col header="End" value="12/30/2014" />
             <col header="Hr/Week" value="80.0" />
             <col header="Pay Rate" value="500000.12" />
             <col header="Pay Rate Display Column" value="888,888" />
 
         </context>
   Invalid Level Choice: Development1 on row 1 column A

     </message>
   </messages>
</response>

失敗 (無環境定義)

<?xml version='1.0' encoding='UTF-8'?>
<response success="false">
 <messages>
     <message key="modeled-import-failed">The Personnel import has failed.</message>
     <message key="error-import">Import Failed with the following error: 1 Error(s) Occurred.</message>
     <message key="import-detail">Additional information:</message>
     <message key="warning-nonexistent-dimension-value">Warning: No data was imported for rows with the following dimension values because the dimension values for Plan do not exist: Development1.</message>
     <message key="invalid-plan-choice-withCoordinate">Invalid Level Choice: Development1 on row 1 column A</message>

 </messages>
</response>