{"id":4996,"date":"2018-10-01T16:21:43","date_gmt":"2018-10-01T16:21:43","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4996"},"modified":"2020-02-20T15:57:23","modified_gmt":"2020-02-20T15:57:23","slug":"connect-workday-power-bi-import-soap-data","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/","title":{"rendered":"Connect Workday in Power BI – Import SOAP Data"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In our previous blog post we saw how to import SOAP API data in Power BI<\/a>. Now let’s continue to explore more use cases. In this article we will check how to Connect WorkDay in Power BI. We will show you step by step approach on how to call Workday SOAP API<\/a> in Power BI and create Power BI reports \/ dashboards using imported datasets.<\/p>\n

We will use ZappySys XML \/ SOAP Driver<\/a> for this demonstration.<\/p>\n

Requirements<\/span><\/h2>\n
    \n
  1. First, you will need to have\u00a0Power BI Desktop<\/a>\u00a0installed<\/li>\n
  2. Make sure you have\u00a0ZappySys ODBC Power Pack<\/a>\u00a0installed<\/li>\n
  3. Download and have install\u00a0SoapUI<\/a><\/li>\n<\/ol>\n

    Get Started<\/h2>\n

    Once above requirements are fulfilled, let’s learn how to use Workday SOAP API and import workday data in Power BI.<\/p>\n

    Here are high level steps to import Workday data in Power BI using ZappySys XML \/ SOAP Driver<\/a>.<\/p>\n

      \n
    1. Craft Workday SOAP request XML using tool like\u00a0SoapUI<\/a>\u00a0for desired operation (e.g\u00a0Get_Employee<\/strong>\u00a0)<\/li>\n
    2. Configure ODBC DSN for Workday SOAP API Connection using ZappySys XML \/ SOAP Driver<\/a>. (Select HTTP Connection with SOAP WSS mode using workday Userid \/ password).<\/li>\n
    3. Test SQL Query for desired SOAP API call<\/li>\n
    4. Finally, Import Data in Power BI using ODBC Connection, Supply Custom SQL Query during Import Process (Crafted in previous step).<\/li>\n<\/ol>\n

      Now let’s look at each step in detail in the following sections<\/p>\n

      NOTE:<\/strong>\u00a0If you are trying to get data from Workday report<\/span> <\/em>instead (your Workday admin created a report and gave you a link) then skip Soap UI part, use the URL with GET method and Basic authentication<\/em> instead of SOAP WSS.<\/div><\/div>\n

      Craft Workday SOAP request XML using SoapUI<\/h3>\n

      Now let’s look at how to use tool like SoapUI to craft SOAP API requests. It would be helpful if you can refer this article to learn more<\/a> about using SoapUI tool (Check SoapUI section in that article).<\/p>\n

      Obtain Workday SOAP WSDL URL (API Metadata URL)<\/span><\/h4>\n

      First step to consume workday api using SSIS is download SOAP WSDL file. WSDL is an XML file which describes available API operations in Workday. It also describes the structure of XML request \/ response. Here is the\u00a0list of available WSDL<\/a>\u00a0for various Workday API Services. You can right click on WSDL icon and save to local disk or use Direct WSDL URL in next section for importing in SoapUI tool<\/a>.<\/p>\n

      You can find more information about Other\u00a0Workday API here<\/a>.<\/p>\n

      Obtain Workday API URL<\/span><\/h4>\n

      Once you have WSDL file, next step is craft correct URL for API service you like to call. Service name can be obtained from\u00a0here<\/a>\u00a0(Check service column). Notice my-instance and my-tenantid placeholders (Its specific to your company).<\/p>\n

      Syntax:\u00a0\u00a0<\/strong>https:\/\/<workday host name>.workday.com\/ccx\/service\/<tenant name>\/<service-name><\/span>\u00a0
      \nExample:\u00a0<\/strong>https:\/\/MY-INSTANCE.workday.com\/ccx\/service\/MY-TenantID\/Human_Resources<\/span><\/p>\n

      Load WSDL in SoapUI<\/span><\/h4>\n

      Now it’s time to load WSDL and craft some SOAP Request and test. For detailed steps check this (watch Video to learn SoapUI tool)<\/a>\u00a0.<\/p>\n

        \n
      1. Open SoapUI tool<\/li>\n
      2. Click new File > New Soap Project<\/li>\n
      3. Enter WSDL Path and Name of the project<\/li>\n
      4. You will see many different operations in the imported project. For example below screenshot shows Human_Resources service and\u00a0Get Employee<\/strong>\u00a0API call. You can fill out necessary parameters in your request \/ remove optional parameters from XML as needed.\n
        \"Create<\/a>

        Create SOAP Request Body from WSDL (Using SoapUI tool)<\/p><\/div><\/li>\n<\/ol>\n

        Configure Soap Request Body, URL and Credentials in SoapUI<\/span><\/h4>\n

        Now it’s time to configure SOAP Request service URL and Credentials. To generate correct Credentials Header in SOAP Request use tool like SoapUI.\u00a0Check this article<\/a>\u00a0to learn more how to generate WSS Security header.<\/p>\n

          \n
        1. Go to the API method you like to call and double click on the default Request node. Check this article to learn more<\/a>.<\/li>\n
        2. Change default request parameters (Add \/Remove as per your need). You can click on Re-generate icon in the toolbar to reset the request and create optional parameters.<\/li>\n
        3. Enter the Service URL
          \nExample:<\/strong>\u00a0\u00a0https:\/\/myinstance0001.workday.com\/ccx\/service\/AB11111111\/Human_Resources<\/li>\n
        4. In the properties window select WSS-Password Type as\u00a0PasswordDigest<\/strong>, Enter workday username<\/strong> and password<\/strong><\/li>\n
        5. Once you done click Play button to execute the request. If things go well then you should see response on your right panel as below.\n
          \"SoapUI<\/a>

          SoapUI – Call Workday SOAP API (Configure WSS Security, Service URL, Body, Test Request \/ Response)<\/p><\/div><\/li>\n<\/ol>\n

          Creating ODBC DSN for Workday Connection<\/span><\/h3>\n

          Once you test correct parameters in your XML Request we can create ODBC DSN for Workday.<\/p>\n

            \n
          1. Open start menu and search for “ODBC 64”. Launch ODBC Data sources for 64 bit\n
          2. Click Add<\/strong> and select ZappySys XML Driver<\/strong>\n
          3. Once driver UI is visible change default DSN name (e.g. change something to \u00a0WorkdayDSN<\/strong>)<\/li>\n
          4. Enter API EndPoint URL (Get it from SoapUI) and Select connection type as HTTP.
            \nExample URL:\u00a0\u00a0https:\/\/YOUR-INSTANCE.workday.com\/ccx\/service\/YOUR-TENANT\/Human_Resources<\/li>\n
          5. Configure HTTP connection as below.\n
          6. Click OK to save connection.<\/li>\n
          7. Now Configure other settings as below.\n
              \n
            1. Select Method as POST<\/strong><\/li>\n
            2. Select Content Type as text\/xml<\/strong><\/li>\n
            3. Enter one required Header for SOAP API as below\n
              SOAPAction :\u00a0 \"\"<\/pre>\n<\/li>\n
            4. Enter Body (Get it from SoapUI ). Here is example body for Get_Employee request.\n
              <soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:bsvc=\"urn:com.workday\/bsvc\">\r\n   <soapenv:Header\/>\r\n   <soapenv:Body>\r\n      <bsvc:Employee_Get>\r\n         <bsvc:Employee_Reference>\r\n            <bsvc:Integration_ID_Reference>\r\n               <bsvc:ID>XXXX-1234-CHANGE-THIS-XXXXXXX<\/bsvc:ID>\r\n            <\/bsvc:Integration_ID_Reference>\r\n         <\/bsvc:Employee_Reference>\r\n      <\/bsvc:Employee_Get>\r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\n
              NOTE: Change ID to your own record id.<\/li>\n
            5. ( Optional )<\/strong> If your API returns more than one record (e.g. if you call API like Get_Workers<\/strong>) then select Filter as per below screenshot (Click Yes if asked to treat selection as array). For example in below screenshot we called Get_Workers request which returns multiple records under wd:Worker node<\/strong>. Look for\u00a0Array Icon<\/strong> in the Filter selection. Skip this step if no array extraction needed.<\/li>\n<\/ol>\n<\/li>\n
            6. After Configuration your screen may look like below.\n
            7. Now go to Preview Tab and you will see default SQL query generated for you. Here is example query (Replace Body part as per your need)\n
              SELECT * FROM $\r\n\/*Below WITH clause is optional, uncomment parameter(s) values you like to set \r\n which are different than DSN properties.\r\n*\/\r\nWITH(\r\n\tSrc='https:\/\/xxxxxxxxxx.workday.com\/ccx\/service\/yyyyyyyyy\/Human_Resources'\r\n\t--,ElementsToTreatAsArray='wd:Worker'\r\n\t--,DataConnectionType='HTTP'\r\n\t--,SoapWssPasswordType='PasswordDigest'\r\n\t--,UserName='testuser001'\r\n\t--,CredentialType='SoapWss'\r\n\t--,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'\r\n\t--,RequestContentTypeCode='TextXmlUtf8'\r\n\t--,RequestMethod='POST'\r\n\t--,Header='SOAPAction: \"\"'\t\r\n\t,RequestData='\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:bsvc=\"urn:com.workday\/bsvc\">\r\n   <soapenv:Header\/>\r\n   <soapenv:Body>\r\n        .......... .......... .......... \r\n        .......... FROM SOAPUI .........  \r\n        .......... .......... ..........        \r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope>'\r\n)<\/pre>\n<\/li>\n
            8. Click Preview button to see data. Copy your SQL Query for later step.\n
            9. Click OK to save DSN<\/li>\n<\/ol>\n
              Import Workday data in Power BI<\/h3>\n
              Now let’s move to the final step. We will use SQL query and DSN created in previous step for data load in Power BI.<\/p>\n
                \n
              1. Open Power BI Desktop<\/li>\n
              2. Click on Get Data<\/strong> > More Data…<\/strong> >\u00a0Other<\/strong> > ODBC<\/strong>\n
              3. Select your ODBC DSN Source<\/strong> from the dropdown (Assuming you have created a ODBC Data Source using ZappySys XML Driver \u2013 See the previous Section)<\/li>\n
              4. Expand Advanced Options<\/strong> to enter custom Query.<\/li>\n
              5. Enter your SOAP API call SQL query here. For example purpose, you can use below query to get all JOB categories.\n
                SELECT * FROM $\r\nWITH(\r\n\t Src='https:\/\/xxxxxxxxxx.workday.com\/ccx\/service\/yyyyyyyyyy\/Human_Resources'\t\r\n\t--,DataConnectionType='HTTP'\r\n\t--,SoapWssPasswordType='PasswordText'\r\n\t--,UserName='testuser001'\r\n\t--,Password='###########'\r\n\t--,CredentialType='SoapWss'\r\n\t,RequestMethod='POST'\r\n\t,RequestContentTypeCode='TextXmlUtf8'\r\n\t,Filter='$.soapenv:Envelope.soapenv:Body.bsvc:Get_Job_Categories_Response.bsvc:Response_Data.bsvc:Job_Category[*]'\r\n\t,ElementsToTreatAsArray='bsvc:Job_Category'\r\n\t,RequestData='\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:bsvc=\"urn:com.workday\/bsvc\">\r\n   <soapenv:Body>\r\n      <bsvc:Get_Job_Categories_Request\/>\r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope>'\r\n)<\/pre>\n
                 <\/p>\n
                \"Import<\/a>
                Import Workday SOAP Web Service Data in Power BI (ZappySys XML Driver)<\/p><\/div><\/li>\n
              6. Once you see data preview click OK to import.<\/li>\n
              7. After data import is done you can edit your dataset (e.g. remove unwanted columns)<\/li>\n
              8. You can also edit Source query after data is imported (See below)\n
              9. That’s it. You can now create your dashboards using data we just imported. See below example.\n
                \"Import<\/a>
                Import Workday data in Power BI dashboard<\/p><\/div><\/li>\n<\/ol>\n
                 <\/p>\n
                Workday API Pagination – Retrieve more than 100 rows<\/h2>\n
                By default Workday API will return only 100 records unless you specify Page \/ Count in Response_Filter<\/a> . Regardless it will only send you 999 maximum rows. To fetch more records after first page you have to setup pagination in XML Driver. Below screenshot<\/p>\n
                  \n
                1. Select Paging Mode= POST Data Mode<\/li>\n
                2. Enter Page Number Indicator (e.g. <%page%><\/strong> )<\/li>\n
                3. Click browse button for Max Pages Expression\u00a0<\/strong> \u00a0(select node which indicates how many pages in response. e.g. Total_Pages<\/strong>)\n
                4. Once this is done go to Settings Tab. Edit your Body and make sure you supply Response_Filter.\u00a0Pass Response_Filter parameter as below. See how we used <%page%><\/strong> placeholder. You can use tool like fiddler<\/a> to see multiple response at runtime. Run package and check fiddler.\u00a0In the below example we are fetching maximum 300 rows per response. It will keep reading until all pages are done. For example if you have 1000 rows to read then it will take 4 response behind the scene.\n
                  <soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:bsvc=\"urn:com.workday\/bsvc\">\r\n   <soapenv:Body>\r\n      <bsvc:Get_Job_Categories_Request bsvc:version=\"\">\r\n        <bsvc:Response_Filter>\r\n            <bsvc:Page><%page%><\/bsvc:Page>\r\n            <bsvc:Count>300<\/bsvc:Count>\r\n         <\/bsvc:Response_Filter>\r\n      <\/bsvc:Get_Job_Categories_Request>\r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\n
                  \"Workday<\/a>
                  Workday API Pagination – Supply Response_Filter (Page Size and Current Page Number)<\/p><\/div><\/li>\n<\/ol>\n
                  That’s it. Now if you run your query it will fetch all pages and you can now read more than 1000 rows. Make sure you configure Count at reasonable size (Rows per Page) in above screenshot we use 5 just to demo small sample. We suggest you to to set around 300.<\/p>\n
                   <\/p>\n
                  How to pass parameters to SQL query in Power BI<\/h2>\n
                  In the real world, many values of your REST \/ SOAP API call may be coming from Parameters. If that’s the case for you can try to edit script manually as below. In below example its calling SQL Query with POST method and passing some parameters. Notice below where paraAPIKey is Power BI Parameter (string type). You can use parameters anywhere in your script just like the\u00a0normal variable.<\/p>\n
                  \n\"Import<\/a><\/p>\n
                  \n <\/p>\n
                  let\r\n    vKey=paraAPIKey,\r\n    Source = Odbc.Query(\r\n\"dsn=ZS - OData Customers\", \r\n\"SELECT * FROM $ WITH (SRC='http:\/\/httpbin.org\/post',\" \r\n& \"METHOD='POST',\" \r\n& \"HEADER='Content-Type:application\/json',\" \r\n& \"BODY=@'{\"\"CallerId\"\":1111, \"\"ApiKey\"\":\"\"\" & vKey & \"\"\"}')\")\r\nin\r\n    Source<\/pre>\n
                   <\/p>\n<\/div>\n
                  How to debug Web Requests using Fiddler<\/h2>\n
                  There will be a time you like to see RAW HTTP Requests generated by driver for NetSuite SOAP API.\u00a0 If you like to do that check this article<\/a>.<\/p>\n
                  Conclusion<\/h2>\n
                  Consuming data from Workday API or any XML \/ SOAP based API in your Reporting \/ ETL apps can be tricky. But we have seen how to solve this challenging task using ZappySys XML Driver in few clicks. Download ODBC PowerPack<\/a> and explore many other API integration scenarios not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
                  Introduction In our previous blog post we saw how to import SOAP API data in Power BI. Now let’s continue to explore more use cases. In this article we will check how to Connect WorkDay in Power BI. We will show you step by step approach on how to call Workday SOAP API in Power […]<\/p>\n","protected":false},"author":1,"featured_media":1665,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[276,278],"tags":[298,67,113,68,7],"yoast_head":"\r\nConnect Workday in Power BI - Import SOAP Data | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Connect Workday in Power BI - Import SOAP Data | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-10-01T16:21:43+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-02-20T15:57:23+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"195\" \/>\r\n\t<meta property=\"og:image:height\" content=\"195\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/\",\"url\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/\",\"name\":\"Connect Workday in Power BI - Import SOAP Data | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png\",\"datePublished\":\"2018-10-01T16:21:43+00:00\",\"dateModified\":\"2020-02-20T15:57:23+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png\",\"width\":195,\"height\":195},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connect Workday in Power BI – Import SOAP Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect Workday in Power BI - Import SOAP Data | ZappySys Blog","description":"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/","og_locale":"en_US","og_type":"article","og_title":"Connect Workday in Power BI - Import SOAP Data | ZappySys Blog","og_description":"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver","og_url":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-10-01T16:21:43+00:00","article_modified_time":"2020-02-20T15:57:23+00:00","og_image":[{"width":195,"height":195,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/","url":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/","name":"Connect Workday in Power BI - Import SOAP Data | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png","datePublished":"2018-10-01T16:21:43+00:00","dateModified":"2020-02-20T15:57:23+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to connect Workday in Power BI. Import data from Workday SOAP API Web Service, Create Report, Pass Parameters for Query. Use XML \/ SOAP API Driver","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/workday-api-integration.png","width":195,"height":195},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/connect-workday-power-bi-import-soap-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connect Workday in Power BI – Import SOAP Data"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4996"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=4996"}],"version-history":[{"count":9,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4996\/revisions"}],"predecessor-version":[{"id":8773,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4996\/revisions\/8773"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1665"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}