Import Scripts run successfully but target module did not update as expected

Options
fssebastian
fssebastian
in Integrations and extensibility

Hi,

We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected.

It seems like it is still importing the old csv file instead of the new one. Also, we are deleting and re-exporting the csv file to the file path folder; we do this to as we have updated file daily.
What could be the possible error for this?

image.png

Please help. Thanks

Tagged:

Answers

  • Stacey_Gibbens
    Stacey_Gibbens
    edited March 12
    Options

    Hi @fsbaste,

    Most likely the account that is being used to run the import action is not the account that originally created the import/original data source. Remember that the import data source is a holding location for your uploaded file and therefore even if you are deleting and replacing the original file on your server, it's not loading properly to the Anaplan workspace server's data source associate with the import action within your model. That's why it would still continue to be the original .csv and not the new one. The original .csv is still there, and it can only be accessed by the user account that built it (unless the action is published on a dashboard, yadda, yadda, yadda).

    It's a funny requirement, but something that's been in effect since Anaplan put security on import data sources many moons ago. It's just one of those funny little gotcha! things that are quirky about integrations. :) The way to get this to work is to build your import actions for your lists and source data that you plan to automate using the service/integration account. You can log in outside of SSO with the service/integration account and configure everything, then run it via the script with a new .csv to ensure it tests out.

    Hope this helps,

    Stacey

  • fssebastian
    fssebastian
    edited March 20
    Options

    Hello @Stacey_Gibbens,

    I apologize for taking so long to comprehend. I'm not sure if we are using specific account to run the action since we have the certificate authentication which is the java keystore.

    Here is the sample bat file that is being run by scheduler.

    set Keystore="C:\anaplan-connect\Anaplan Converted Cert\.jks"
    set KeystoreAlias=""
    set KeystorePassword=""
    set WorkspaceId=""
    set ModelId=""
    set ServiceUrl="https://api.anaplan.com"
    set AuthUrl="https://auth.anaplan.com"
    set FileName=".csv"
    set FilePath="D:\csv"
    set ImportName=""
    set DumpName=""
    set Chunksize=1

     

    set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -output %DumpName%
    set Credentials=-keystore %Keystore% -keystorepass %KeystorePassword% -keystorealias %KeystoreAlias%

    Does this need specific account? please help. Thank you!

Categories