File delimiter changes after API execution

Options
Sivasankar
Sivasankar Member, ALL USERS, Certified Model Builder Posts: 5 Contributor
in Extensibility

Hi Experts,

We use Anaplan connect 1.4.4 to import data from SQL. we noticed that after import execution the file delimiter default itself to "Tab" even though it is set to "Comma" delimiter. this is weird. 

Interesting part is even if the action changes from comma to tab further load using the same API call works when it was imported using Anaplan client 1.4.4 but this is not working when this action is called from AWS API (v2)

@Echo off

set ActionName="1.1 Current date upload from SQL"
set ActionFile="Current_Date.csv"
set JDBCFile=JDBC_Current_Date.properties
set ErrorFile=Current_Date_Error.txt

set Operation=-auth %AuthUrl% -file %ActionFile% -jdbcproperties "%JDBCpath%\%JDBCFile%" -import %ActionName% -execute -output "%Errorpath%\%ErrorFile%"
rem *** End of settings - Do not edit below this line ***
setlocal enableextensions enabledelayedexpansion || exit /b 1

cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %DatahubWSID% -model %DatahubModelID% %Operation%

cmd /c %Command%

Action is configured as "Comma" delimiter

Sivasankar_0-1616160711595.png

After executing the API import, the delimiter automatically changes to "TAB" from "COMMA"

Sivasankar_1-1616160823528.png

Please suggest why delimiter changes after Anaplan connect 1.4.4 API call

 

Regards,

Siva

 

 

Tagged:

Comments

  • Sivasankar
    Sivasankar Member, ALL USERS, Certified Model Builder Posts: 5 Contributor

    @DaanishSoomar yes tried to create one import from scratch but result is the same

     

    Will forward this request to support team

     

    Regards,

    Siva

  • Sivasankar
    Sivasankar Member, ALL USERS, Certified Model Builder Posts: 5 Contributor

    @DaanishSoomar yes even after changing the delimiter it loads with the same batch using Anaplan client 1.4.4. but when we try to load data using the same action from AWS API (v2) it prompts error

    -

    -

    -

    The dimensions in the target module do not match the import definition."],"$type":"Detail"}]}

     

    Regards,

    Siva

  • Sivasankar
    Sivasankar Member, ALL USERS, Certified Model Builder Posts: 5 Contributor

    @DaanishSoomar do you know how to forward this request to support team from here

     

    Regards,

    Siva

  • Kudiarasu
    Kudiarasu Member, ALL USERS, GroupMember, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Hi

    I am facing similar issue, any update from support? 

    Thanks

    Kudi

Categories