Updating a table with the file name of a file being inserted into a file browser in Jitterbit App Builder
Step-by-step guide
- Create a new Business Object on the File table (File (Source) as an example) for the file browser and add Shared('field') to the Business Object.
- Point the File Browser page on the UI to the new Business Object.
- Add shared binding to the link of the file browser page. This will pass in the Primary Key of the table you want to update.
- Create a XP CRUD XP Rule on Insert of the new Business Object. Inside of the rule have FileName (targeted), Directory, DataSourceID, Content, and caller('SharedField') targeted to the Primary Key of the table you want to update. Using explicit binding, bind the Primary Keys from the File table.