Docebo Connect - Pull in Session Additional Fields
In Docebo Connect, I created an ILT schedule report pulling in fields using the Get Sessions by Course ID call. I have the data export and create rows in Google Sheets.
My challenge is, I am not able to bring in session additional fields in Connect because they cannot be selected and brought in as data pills. I have two session additional field values (ID 19 and ID 21) that I want to bring in to this file for each row/session in my file. Any idea how to achieve this in Connect?
Page 1 / 1
Hi @williamradford14 not sure if this helps get what you’re after but this is an API endpoint for sessions that appears to return the additional fields. I haven’t had a need to use it so haven’t tested it but the response schema seems to show that data is returned. You might need to build your recipe to first get the session ID’s by course, then run this endpoint to get the session additional fields and do whatever else is needed. It’s not uncommon to have to piggyback API endpoints in your recipe to get what you need. Hope this helps.
Wow- thanks for that. That worked perfectly.
After the get sessions by course id -
repeat for each session —> get session by session id → repeat for each additional fields —> IF condition and variable creation for one additional field ID —> add to file
This endpoint also opened up other fields I needed. My next challenge is trying to figure out how bring in more than one additional field!
Actually, I figured it out. I had to do another For Each, If, create variable set for the additional, additional field. Not sure if that is the most efficient, but it worked.