Course Navigation Items

[a1222679]

With CD1 I used to be able to get a list of all the items in the navigation bar for a course.

In the CD2 documentation it says that I should be able to find this information in the Courses table...

• tab_configuration (Annotated[bounded_str, JsonStringToJsonObject(), SpecialConversion()] | None) – A JSON serialized list detailing the order and visibility status of tabs in the left-hand navigation for the course.

However, I can't see tab_configuration in there.  Does anyone know how I can get this information?

[sgergely]

I have just run 

dap snapshot --namespace canvas --table courses --format csv

on my test account and there is a value.tab_configuration column filled up with JSON in my CSV. 
It is also available in the documentation, but I guess you have copied the info from there. 

What tool have you used to get your data through the Query API?

[a1222679]

The data is stored in our data warehouse and I query all courses from there in Power BI.  I haven't been running API queries at all.

[stimme]

@a1222679 Unlike CD1's course_ui_canvas_navigation_dim table, CD2's courses.tab_configuration field is null when the course navigation menu has not been modified. It is a shame that the documentation does not explicitly say default values are excluded from the field.

There was a thread about this table last year that may be helpful to you. CD2 Courses table - tab configuration field .

[a1222679]

Thank you @stimme I hadn't seen that.