4 Replies Latest reply on Oct 2, 2017 8:08 AM by Osman Erzinclioglu

    Importing Leads From Workday XML Report

    Osman Erzinclioglu

      Hello,

       

      We're trying to import leads from a Workday custom report. It's an XML report accessible through a URL behind authentication.

       

      The XML is in the following form:

       

      <wd:Report_Data>

      <wd:Report_Entry>

        <wd:Person_ID>00001</wd:Person_ID>

        <wd:Full_Name>Osman Erzinclioglu</wd:Full_Name>

        <wd:Last_Name>Erzinclioglu</wd:Last_Name>

        <wd:First_Name>Osman</wd:First_Name>

        <wd:Title>Technical Support Analyst</wd:Title>

        <wd:Contact_Type>Employee</wd:Contact_Type>

        <wd:Email_Address>first.last@site.com</wd:Email_Address>

        <wd:Company>

          <wd:Company_Code>XXX</wd:Company_Code>

          <wd:Company>AGF Investments Inc.</wd:Company>

        </wd:Company>

      </wd:Report_Entry>

      <wd:Report_Entry>

        <wd:Person_ID>00002</wd:Person_ID>

        <wd:Full_Name>Bob Hope</wd:Full_Name>

        <wd:Last_Name>Hope</wd:Last_Name>

        <wd:First_Name>Bob</wd:First_Name>

        <wd:Title>Funny Guy</wd:Title>

        <wd:Contact_Type>Employee</wd:Contact_Type>

        <wd:Email_Address>bob.hope@site.com</wd:Email_Address>

        <wd:Company>

          <wd:Company_Code>XXX</wd:Company_Code>

          <wd:Company>AGF Investments Inc.</wd:Company>

        </wd:Company>

      </wd:Report_Entry>

       

      ... and so on, and so on...

       

      </wd:Report_Data>

       

      There are a few hundred records and we want to import/update the entire list on a weekly basis.

       

      What's the easiest way to pull this data into Marketo?

       

      I read some content on the developers blog about response mappings for webhooks, but that looks like a means for updating data on a specific lead rather than a means for creating new leads.

       

      Do we need to get a developer involved and use the API, or is there some other way to import/update these leads that won't require development?

        • Re: Importing Leads From Workday XML Report
          Sanford Whiteman

          XML isn't a valid UI-based import type*. You'll need to map it to CSV.  Certainly someone who's good with XPath/XSLT could write a reusable script to flatten that format pretty easily; Excel et al. have XML awareness but it's always driven me up the wall and I've worked with the file on its own instead.

           

          You're correct, webhooks only make sense for existing leads. In a wild world, you could extract just the email addresses, import those as a one-column CSV, then run them through the webhook to get the rest of the data. But you'd need to have a server to only pass back the part of the XML that applies to the current lead.  So really more complex, not less.

           

          Do people still think Bob Hope is a funny guy?  He wasn't so... woke.

           

          * Nor API-based type unless you're using SOAP. But it would be different XML anyway.

          1 of 1 people found this helpful