Get a list of fields and field values from a document on the server

[#1]

Are there any API/SDKs that allows to get a list of fields and field values from a Qlikview document that is residing on the Qlikview Server?

The QMS API doesn't seem to allow that. There seems to be an undocumented QVS API that is XML based but I'm not sure how to use that to get the relevant information. Any help?

I've seen that the commercial QVSConnector component does something similar, possibly using the undocumented API however I would like to know how to implement similar functionality myself.

[#2]

I do not know but would be very interested if you found a solution.

[#3]

Hi,

I'm facing similar issue.

Have you found a solution to this.

Thanks,

Arnold

[Alexander_Thor]

I'm not sitting at a computer with vs installed atm so can't try it but have you looked into the GetFieldList & GetFieldContents methods implemented in the QMS interface?

Here is a sample from the SDK:

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();
            ServiceInfo serviceInfo = apiClient.GetServices(ServiceTypes.QlikViewDistributionService).FirstOrDefault();
            if (serviceInfo != null)
            {
                QDSDocumentSessionConfiguration sessionConfig = new QDSDocumentSessionConfiguration();
                sessionConfig.QDSID = serviceInfo.ID;
                sessionConfig.FilePath = @"C:\ProgramData\QlikTech\SourceDocuments\Sales.qvw";
                QDSDocumentSession documentSession = apiClient.CreateSession(sessionConfig);
                if (documentSession != null && documentSession.OpenDocumentResult == DocumentState.OpenedSuccessfully)
                {
                    List<Field> fields = apiClient.GetFieldList(documentSession);
                    fields.ForEach(f=>Console.WriteLine(f.Name));
                    apiClient.CloseSession(documentSession);
                }
                else
                {
                    Console.WriteLine("Failed to open the document.");
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("An exception occurred: " + ex.Message);
        }
        // wait for user to press any key
        Console.ReadLine();
    }
}

[jonathandienst]

Hi

Have a look at Metascanner:  http://community.qlik.com/docs/DOC-1783

Regards

Jonathan

[#6]

Thanks for the Code.

But I'm getting  "Service Key is Missing" error.

Kindly help advice how to resolve this issue.

Thanks,

Arnold