Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-08
Example: Extract DSN Submissions to Excel (FRA)

Example: Extract DSN Submissions to Excel (FRA)

This example illustrates how to create an EIB to extract a manual DSN submission to Excel. You can also set up Workday-generated Excel files with the
DSN Deposit (Machine to Machine)
 integration. See Example: Set Up the DSN Submission Event Business Process (FRA).
You want to extract your monthly DSN submissions to:
  • Verify the submission before sending the DSN file to net-entreprises.fr.
  • Archive the sent DSNs.
  • Create a DSN submission.
  • Create a custom XSLT attachment transformation named
    DSN Excel Transformation - Custom
     based on the latest version of the
    DSN Excel Transformation.xslt
     file. You can download the
    DSN Excel Transformation.xslt
     from Workday Community.
  • Security:
    • Integrations: EIBs
      ,
      Integration Event
      , and
      Integration Build
       domains in the Integration functional area.
    • Process: DSN (Submission) - FRA
       domain in the FRA Payroll functional area.
    • Your tenant must have a definition for the
      Integration Process Event
       business process including the
      Initiation
       and
      Fire Integration
       steps.
  1. Access the
    Create Web Service Data Source
     task.
  2. Select
    Get DSN Data (Web Service)
     from the
    Web Service Operation
     prompt.
  3. Click
    OK
    .
  4. From the related actions menu of the data source, select
    Web Service Data Source
    Edit
    .
  5. In the
    Request XML
     field, enter:
    <wd:Get_DSN_Data_Request xmlns:wd="urn:com.workday/bsvc">
 <wd:Request_References>
  <wd:DSN_Submission_Reference>%DSN Submission Reference%</wd:DSN_Submission_Reference>
 </wd:Request_References>
 <wd:Request_Criteria>
  <wd:Show_DSN_Structure>1</wd:Show_DSN_Structure>
 </wd:Request_Criteria>
</wd:Get_DSN_Data_Request>
  6. In the
    Launch Parameters
     grid, enter these values:
    Name
    Launch Parameter Type
    Options
    DSN Submission Reference
    Select
    Data Type
    , and then the self-referencing report field,
    DSN Submission
    .
    Required
  7. Access the
    Create EIB
     task and enter these values:
    Option
    Value
    Name
    DSN Excel Export
    Outbound
    Checked
    Data Source Type
    Web Service
    Web Service
    Get DSN Data (Web Service)
    Transformation Type
    Custom Transformation
    Custom Transformation
    DSN Excel Transformation - Custom
    Delivery Method
    Workday Attachment
Workday generates the DSN submission as an XML file, which you can then open in Excel.