After the Community Coaching Session: Using Postman

  • 11 January 2024
  • 36 replies
  • 280 views
Bfarkas
Rank
Userlevel 7
Badge +3

The second Community Coaching session has come and gone, and so many came to learn how to use Postman with their Docebo instance. Thank you all for setting the time aside, these sessions are only great when you show up :)

As promised, to help you get up and going a tad quicker in Postman, I made a Collection to share with security preconfigured, and many common API’s loaded and ready to use. It is a great starter library to use as your getting more comfortable using the program.

 

The JSON file is attached to this post as a zipped file. Download, extract, and use the steps below to import it into your Postman. 

Note: I had to break this post up a bit into the comments below, please look through for appropriate steps.

1 Attachment

36 replies

JKolodner
Rank
Userlevel 5
Badge

@Bfarkas - Whoah. I have now gone through all the steps you outlined and created an Excel workbook that can be refreshed with future exports from the Postman queries. I then used the tutorial below to combine the data from the multiple sheets into one combined sheet which is the product I actually need. I’m going to try to refresh the data and see if everything still works. 

 

This is some serious magic.

Jennifer
Bfarkas
Rank
Userlevel 7
Badge +3

YESS!!! YOU DID THE THING!!!

 

 

Sorry I skipped out on the details for merging, nice find on the above, keep in mind the way you are importing builds those queries for you, so there is also a built in merge option on them:
 

 

Select the other query from the drop down, and then make sure to update the ‘Join Kind’ to ‘Full Outer’ so it includes all rows of both, you also have to select the columns you want from each which is not clear:
 

 

And then fun fact, you don’t actually need the tables that were created for the previous ones, the connections still live:


 

When it comes to the update, make sure to just replace the files, not delete. You can always remap the query where the file is if needed. Also, I often save these in bundles in a shared online space so i can share with other users.

Finally, I know I mentioned it, but I can’t emphasize enough, set the properties of each query to update on document load, its lovely. :)

 

 

JKolodner
Rank
Userlevel 5
Badge

No worries! I’m a fan of Chester Tugwell’s videos. They’re always very clear!

But I’m going to try your version now. And I’m going to double-check that I set the query properties for update on reload. 

SO EXCITED!

Jennifer
JKolodner
Rank
Userlevel 5
Badge

I’ve used the Power Query merge before, so the merge method you mentioned looks familiar. But it looks like I can only merge two sheets. And since I have 5 sheets, I think I’ll stick with my version.

Jennifer
Bfarkas
Rank
Userlevel 7
Badge +3

I’ve used the Power Query merge before, so the merge method you mentioned looks familiar. But it looks like I can only merge two sheets. And since I have 5 sheets, I think I’ll stick with my version.

Makes sense, you can kind of merge both methods too :) but on this almost long weekend, you have a solve so go grab your beverage of choice, cheers!

JKolodner
Rank
Userlevel 5
Badge

Now continuing I can almost hear your next question @JKolodner , but I only connected one file and Docebo API is making me page it out….annoying right?

Well, here’s a nice thing, you can repeat the excel process again, inside the same excel, with multiple JSON’s. On that query/connection panel on the right, if you right click one of them, there is an option to ‘Merge’. SO you could put all the pieces together and merge them into one giant table within excel, and then you would just need to add new files.

 

Ah, I think you’re saying here that I could merge two, then merge the 3rd one in, then the 4th, then the 5th. Clever!

Jennifer
lrodman
Rank
Userlevel 7
Badge +5

Hello! Is a recording of the session (or today’s DU live) available for my team members who missed it?

Thanks!

Bfarkas
Rank
Userlevel 7
Badge +3

Yup, @lrodman this one is here:

 

Today’s will be available soon, along with the other DU Lives. This post usually gets updated with it once ready:

 

luca.rossi
Rank
Userlevel 2

@Bfarkas hey, thank you for your guide.

i have this error when i click on “Get new access token”:

{"error":"redirect_uri_mismatch","error_description":"The redirect URI provided is missing or does not match","error_uri":"http:\/\/tools.ietf.org\/html\/rfc6749#section-3.1.2"}

thank you for your help

 

Luca

 

Setting Up Authentication

 

Great, you have successfully imported the collection, in order to use it, make sure to finish configuring the Authorization tab and generate a token. To do that follow these steps:

  1. Select the top level of the Collection ‘Docebo API for Sharing’.
  2. Switch to the ‘Authorization’ tab:

     

  3. Scroll down and fill in the ‘Client ID’ and ‘Client Secret’ fields using the information from your Docebo instance. If you do not know how to get these/configure them, see the next section below.
  4. Make sure to select ‘Save’ in the top right:

     

  5. To help this template be more flexible, we used variables for the base URL throughout, including the Authorization area. You need to enter your domain into that variable. To do this, switch to the ‘Variables’ tab:

     

  6. Enter your domain into the ‘Initial Value’ and ‘Current Value’ box next to the ‘base_url’ variable:

     

  7. Make sure to click ‘Save’ in the top right corner.
  8. Return to the ‘Authorization’ tab.
  9. Now it is time to generate a token, select the ‘Get New Access Token’ button.
  10. Log in if you are not already, if you are select Authorize to proceed:

     

  11. Select ‘Use Token’:

     

  12. Make sure ‘Auto-Refresh’ is toggled on, it should automatically do so:

     

  13. That’s it, you are set to go and run API calls throughout this collection.

 

 

Bfarkas
Rank
Userlevel 7
Badge +3

This error means the URL you put in Docebo on the OAuth2 configuration page and the URL you have in the authentication tab you referenced above for the redirect do not match, make sure both spots have the same one for postman. 

JKolodner
Rank
Userlevel 5
Badge

@Bfarkas I just bookmarked this page because it’s that useful. Thanks again and have a great weekend.

Jennifer

Reply


Terms & ConditionsCookie settings