generate_fo_workbook
Reads Foundation Objects and Picklists from a live SAP SuccessFactors instance and outputs a dated Excel workbook with headers preserved from the client template.
Instructions
Generate a populated Object & Picklist Data workbook from the live SF instance.
Reads all Foundation Objects (Legal Entity, Business Unit, Division, Department, Cost Center, Job Family, Job Function, Job Code, Location, Pay Grade, Pay Range, Pay Group, Pay Component, Pay Component Group, Event Reason, Time Type, etc.) and Picklists, then writes them to a dated Excel file in exports/.
The output file format exactly matches the client template column layout. Header rows 1-2 are preserved from the template. Data starts at row 3.
Returns: { file, sheets_populated, sheets_skipped, summary, warnings }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entities | No | Sheet names to populate: 'all' for all 28 sheets, or a comma-separated list like 'Department,Event Reason,Location' | all |
| data_center | No | ||
| auth_user_id | No | ||
| auth_password | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||