Importing data into Integration tables

Hi,

i'm trying to run the ModelingExecuteIntegrationTableLoadQuery function to load dato into the Budgeting Main integration table but i'm not able to understand the sintax to add parameters here as Variant Dictionary data type (considering that at the end I expect to pass these parameters through Application Studio).

ModelingOperationResult test = ModelingExecuteIntegrationTableLoadQuery("BudgetingMain", "DEPMAPPS", "M3_Q90_Integ_BudgetingMain_FullLoad", true, ??? );

I search the Infor docs with no result. Please can someone advice about this feature?

Thanks in advance.

Alberto

Find more posts tagged with

Infor EPM Discussions

Comments

Peter Mayall

Try:

            VariantDictionary params = CreateVariantDictionary();
            params["Year"] = sourceYear;
            ModelingOperationResult test = ModelingExecuteIntegrationTableLoadQuery("BudgetingMain", "DEPMAPPS", "M3_Q90_Integ_BudgetingMain_FullLoad", true, params);

In this example, I am passing one parameter called "Year".

apiazza

Hi Peter,
just change the params with prms (it tell me it's a reserved word).
When I try now I get the error below. There is a special sintax for a table name?

#define EngineVersion 5.0
#define RuntimeVersion 5.0

string Modeling_Add_Type_as_Integration_BudgetingMain(string sourceYear)
@Description: "This Script ImportData from a Staging Table into an Integration table";
@Category: "BusinessModeling";
@Returns: "if the process is sucessful without any Error a string with success message will be retured else false";

@Parameter[sourceYear]: "Staging Table";
{
string errMsg = "Success";
int errCode=0;

try
{

//SQLConnection sqlConn = SQLCreateNamedConnection(StagingTable);

VariantDictionary prms = CreateVariantDictionary();
prms["Year"] = sourceYear;
ModelingOperationResult test = ModelingExecuteIntegrationTableLoadQuery("BudgetingMain", "DEPMAPPS", "M3_Q90_Integ_BudgetingMain_FullLoad", true, prms);

}
catch(errMsg, errCode)
{
return "Failed: " + errMsg;
}

return "ok";

}

Execute Process: Modeling_Add_Type_as_Integration_BudgetingMain
Parameter sourceYear = 2024
Compiler result: 0
Compiler message:
OK

Method result: Failed: Calling function 'ModelingExecuteIntegrationTableLoadQuery' failed with this message: Failed to clear data: Unknown table specified: BudgetingMain
Executing the process took 582 milliseconds.

Copyright © 2025 Infor. All rights reserved.