Michael Tan (tanm1)
Senior System Architect
Pegasystems Inc.
tanm1 Member since 2016 39 posts
Posted: July 25, 2017
Last activity: August 1, 2017
Posted: 25 Jul 2017 23:56 EDT
Last activity: 1 Aug 2017 23:37 EDT

Sourcing content from BOX by batch

How do I automatically integrate with BOX? Articles such as the following describe how to manually integrate (a logged in user interacts with screen popups to select the location and file, and if necessary log in with userid and password),

but if we need a nightly batch to automatically pull a file from BOX, is that described somewhere?

To be specific we need to

  • run at a fixed time every night independent of any user's login session (so probably use an agent),
  • authenticate itself automatically into BOX (credentials can be hard coded, but not ideal if there's a better way),
  • access a predefined directory (hard coded is ok),
  • download any files with the current date in YYYYMMDD format appended in the file name just before the extension;
  • read the contents of each files into a data class (the file will be CSV)

So a file of the name "departments_20170802.csv" would be downloaded at 01:00 today and loaded into a data class probably named Departments.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.