5 Replies Latest reply on May 21, 2020 9:01 PM by Shelly Thomas

    Create an API to load multiple records to Workday - one by one

    Shelly Thomas Active Member

      Hi ,

       

      I am trying to create an API to load array of data (multiple records) to Workday . I am able to successfully load one record but I want to load multiple records to it

       

      I am just not getting the right way to start with. Searched a lot of approaches, but nothing helped.

       

      Regards,

      Shelly.

        • 1. Re: Create an API to load multiple records to Workday - one by one
          Sorabh Agarwal Support Moderators

          Hi Shelly,

          This can be done two ways:

           

          1. Take the input as a list. Take each item from the list and perform operation on Workday. Then iterate over this design by using Jump / decision / assignment step to read the next item in the list and invoke Workday API and so on....

          2. Use bulk / batch API from Workday, if available, which takes input as a list and perform bulk operation.

           

          Option 2 is preferred over 1 as it should be efficient than 1.

           

          Thanks,

          Sorabh Agarwal

          Informatica Cloud Product Management

          • 2. Re: Create an API to load multiple records to Workday - one by one
            Shelly Thomas Active Member

            Hi Sorabh,

             

            Thanks for your reply.

             

            For option 2 , bulk/batch API option is not available in the service connector of Workday.

             

            Please let me know if I am missing something here.

             

            Regards,

             

            Shaili Shah

            • 3. Re: Create an API to load multiple records to Workday - one by one
              Sorabh Agarwal Support Moderators

              Hi Shelley,

              Service Connector can only support as much as the API provides. Probably Workday does not have a bulk API. In that case, you have to go with Option 1.

               

              1. Take the input as a list. Take each item from the list and perform operation on Workday. Then iterate over this design by using Jump / decision / assignment step to read the next item in the list and invoke Workday API and so on....

               

              Thanks,

              Sorabh Agarwal

              Informatica Cloud Product Management

              • 4. Re: Create an API to load multiple records to Workday - one by one
                Ankit Tripathi New Member

                Hi Shelly,

                 

                As per me there is no Bulk API available out of the box you would have to build a support framework (Strenuous):

                 

                Workday’s native SOAP API specification does not support bulk (a.k.a. batch) data. So, if your use case requires that data is moved in bulk - say to seed an employee database - you will need to build out a full bulk support framework or write extensive code to move data objects one record at a time. If you’ve not done that before, take our word for it, it is not as easy as it sounds. There is a lot that you have to account for, including endpoint API request limits, file chunking, error handling, asynchronous processing, callbacks, and so forth. However, every Element in the Cloud Elements catalog has a built in bulk framework, and our Workday Element is no exception. The integration accommodates for Workday’s missing bulk API support by providing bulk resources out of the box.

                 

                If the number of records is not huge use the List option suggested by Sorabh or write the data into a file and then load the data if its possible to get direct access through Workday connector and use CDI to load the data.

                 

                Regards,

                Ankit Tripathi

                • 5. Re: Create an API to load multiple records to Workday - one by one
                  Shelly Thomas Active Member

                  Hi Ankit, Sorabh,

                   

                  Thank you for your reply.

                   

                  I was able to achieve this. I created the API job with List loop and its working perfectly fine.

                   

                  Thanks for all your help.

                   

                  Regards,

                   

                  Shaili Shah