EPM retrieve data from Data Lake using: infor.LastModified - LAST_IMPORT in Application Engine

Mauricio Mendoza

HI Community,

I trying to automate the load data using the function "infor.LastModified() > '<<LAST_IMPORT>>" from Application Engine  but get errors: The query syntax is incorrect or invalid.

Someone has experience connecting to data lake and using this sentence? If I run these sentence from staging works fine.

My goal is retrieve the last import data from Data Lake using application engine code.  

I appreciate your comments or ideas. Thank you.

#define EngineVersion 5.0
#define RuntimeVersion 5.0

void CargueDataLakeStaging()
@Description: "Describe your process here";
@Category: "Place your process category here";
@Returns: "Place the return value description here";
{
    // 1. Connect to Relational SQL Staging
    SQLConnection sql_connection = SQLCreateNamedConnection("DEPM_Staging");

    SQLConnection datalake_connection = SQLCreateNamedConnection("data_lake");

    SQLData exportdatalake = SQLExecuteQuery(datalake_connection, "--*includeInSelectAll=s/g/p/l SELECT * FROM  WF_Position where infor.LastModified() > '<<LAST_IMPORT>>'", 0);  

unknown

Execute the load query from the App Engine process using the command 

See the online documentation for details, there are several variations.ModelingOperationResult ModelingExecuteTableDataLoadQuery(string applicationName, string tableName, string queryName, bool clearData)