Extracting objects in configuration folder structure

Hi

We currently in CME have a folder structure that looks something like this:

• BussinessUnit1
  → Places
  → Location1
  → Location2

• BussinessUnit2
  → Places
  → Location1
  → Location2

and so on.

I would like some kind of non manual way to make a list of all the places asigned to each business unit.

I have been thinking a bit and the only thing I can come up with right now is using the platform SDK to extract the information on the places and folder, but that seems to be a lot of work, there must be a easier way.

I looked at the config database, but I can see how I can (using SQL) relate places to the containing folders.

Can someone provide hints to the easiest way to extract data like this? Maybe I am mssing something obvious.

Hi,

Rather than using the PSDK you could always use the GAX APIs to get objects (including their folder DBID) and do some scripting in something like Postman. The easy way to find the URLs/APIs is to perform the same action in GAX and then use browser debugging to view the HTTP request and responses and associated JSON payloads.

Regards
Craig