Click or drag to resize
IQMSGetSectionAccessTables Method
Retrieves all defined SectionAccessTable's. Each table contains information about its columns, but no table data is returned.

Namespace: PIX.Services.V12
Assembly: 
Syntax
List<SectionAccessTable> GetSectionAccessTables(
	SectionAccessScope scope
)

Parameters

scope
Type: PIX.QMSAPI.DataObjects.EnumsSectionAccessScope
The scope of the returned value.

Return Value

Type: ListSectionAccessTable
A list of SectionAccessTable's
Remarks
Security note Security Note

Requires membership of local groups QlikView Management API and QlikView Administrator.

Examples
This example retrieves a list of all tables and prints their names and IDs

The service key injection is assumed to be handled behind the scenes. For an example of how to inject the service key, see Samples.

C#
using System;
using System.Collections.Generic;
using System.Linq;
using QMSAPI;

class Program
{
    static void Main(string[] args)
    {
        try
        {
            // create a QMS API client
            IQMS apiClient = new QMSClient();

            //retrieve a time limited service key
            ServiceKeyClientMessageInspector.ServiceKey = apiClient.GetTimeLimitedServiceKey();        

            List<SectionAccessTable> sectionAccessTables = apiClient.GetSectionAccessTables(SectionAccessScope.None);

            sectionAccessTables.ForEach(table=> Console.WriteLine(string.Format("ID:{0}\tName:{1}",table.ID, table.Name)));
        }
        catch (Exception ex)
        {
            Console.WriteLine("An exception occurred: " + ex.Message);
        }
        // wait for user to press any key
        Console.ReadLine();
    }
}
See Also