Skip to main content

Hello!

I am using Docebo Connect to perform scheduled user data imports from a Workday report to Docebo. This is the typical “Batch Employees Import from Workday Report (RaaS)” that’s commonly used to create new user accounts automatically and bring in their standard user data such as username, first/last name, direct manager, etc.

Beyond those standard data pieces, we’ve created additional fields for other items included in the report (e.g. leadership team, number of direct reports, etc.) and have been manually maintaining that data through CSV imports.

However we’d love for those additional fields to be populated as part of our current Workday recipe. I’ve attempted to modify our recipe to include these fields, but through the experimenting and research I’ve done, I haven’t been able to successfully connect the data pills of the Workday report to the additional fields.

Has anyone successfully connected Workday report columns to additional fields through Docebo Connect? Or am I barking up the wrong tree trying to modify the “Batch Employees Import from Workday Report (RaaS)” to include additional fields?

Thanks for any insight!

@sdecoste - good afternoon - can I ask a silly question - can you support this using the automation app?

Does workday support an SFTP site that you can get a file from with those additional fields? If it can - you may be able to do a processing run where you get a file from the SFTP after your initial run via Docebo Connect.

This is a workaround though…..

Beyond that - you may want to chat with an implementation partner like eSkillz - they have Burt McCollum who has done presentations on Docebo Connect (and they implemented a connector with us) at Docebo Inspire for some basic advice on how to go about adding those additional fields to your feed(s).

Hello @sdecoste,

we’ve done exactly that as well. We have our recipe running twice a day to create new platform users and update info on existing users with data from Workday, using a report.

When we created the recipe, we actually did that with the support of Workato (we had to pay for it ofc), who had weekly workshops with us. Unfortunately it’s been a while since we created the recipe, so I don’t remember everything. I mainly remember that we had to edit the scheme in “User Import in Docebo” to add our custom fields. I think you could do that via “Add field” or editing the code directly. Once the fields were created, we just mapped the data categories from the report to the custom fields and it worked in the end. I remember making some simple mistakes like mapping the pills from the wrong step in the recipe which didn’t work. But to answer your question (I guess), yes. It’s definitely possible to import custom data from your report in the recipe. You just need to create the additional fields and do the mapping.

Hope that helps.

 

Hi @sdecoste -- we’re doing exactly this and just earlier today I mapped a new field in our Workday report to one of our many user additional fields. I may be able to help.

I suspect that you’re running into issues because you’ve not updated your schema for the step “Batch User Import in Docebo”:

Our additional fields have been added to the schema
When you modify the schema, it looks like this.

You may be wondering how to get the field names (e.g. how did we know that field_21 is “Business Title”?) -- the best way I know is to use the API Browser:

https://:yoururl.com]/api-browser/#!/manage/Userfield/Userfield_manage_v1_user_fields

First, sign in with Oauth, then click “Try” for the endpoint “Retrieves the list of user additional fields, filtered on input parameters”

I’m not sure if this will solve all your problems but I hope it’s a good start. If you can otherwise share more detail around the problems you’re facing, I may have something else to add.

Thank you @Ian ! That was the exact missing piece we needed! We had just resigned ourselves to reaching out to tech services for some consultation since I could not find a solution to get this working. Thank you for the screenshots and advice on where to find those field names - it’s working perfectly for us!

Reply


Terms & ConditionsCookie settings