Like to create a report of inventory in SDL, is there an API I could use to generate this report

The content developers would like to get an excel report, listing out topics & maps and possibly there relationships in a report form. I couldn't find any out of the box functionality to generate this report, are there API's I could use to run queries and manipulate the data after to generate the report?

Parents
  • I second what Dave said, the question is a bit too vague, so difficult to answer. But, by way of examples, examples of reports I generate via APIs:

    • List of publications in a baseline (we normally have more than one publication attached to the same baseline, to ensure version management is consistent),
    • Publication reports
    • List of objects in a baseline
    • Publishing contexts for all publications in a baseline (for archiving purposes)

    ...and so on. For each report type you can pretty much include any metadata fields you want, the limiting factor there is that collecting some information requires more API calls and processing...it can become time-consuming (but since it is automated, you can leave it running in the background).


    Personally I am using Python 2.7.11. and Suds module for SOAP API calls.


    HTH

    Joakim

Reply
  • I second what Dave said, the question is a bit too vague, so difficult to answer. But, by way of examples, examples of reports I generate via APIs:

    • List of publications in a baseline (we normally have more than one publication attached to the same baseline, to ensure version management is consistent),
    • Publication reports
    • List of objects in a baseline
    • Publishing contexts for all publications in a baseline (for archiving purposes)

    ...and so on. For each report type you can pretty much include any metadata fields you want, the limiting factor there is that collecting some information requires more API calls and processing...it can become time-consuming (but since it is automated, you can leave it running in the background).


    Personally I am using Python 2.7.11. and Suds module for SOAP API calls.


    HTH

    Joakim

Children
No Data