Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
moleroalonso
Contributor II
Contributor II

Problem with method "CreateObject" when qType="sheet"

Hi,

I'm trying create a "sheet" throught API Engine with "CreateObject" but instead of create a sheet the method removes all sheets and new sheets can't be create from the GUI, the app becomes useless.

I follow theses steps:

-1 Connect to Engine

-2 Open doc, with OpenDoc method

-3 Send a CreateMethod request:

     {     "jsonrpc": "2.0",

          "id": 1,

          "method": "CreateObject",

          "handle": 1,

           "params": [

               { "title": "Sheet 1",

                 "description": "Description of sheet 1",

                 "qInfo": {

                         "qId": "SH01",

                         "qType": "sheet" },

          "qChildListDef": {

           "qData": { "title": "/title",

                          "description": "/description",

                          "meta": "/meta",

                          "order": "/order",

                          "type": "/qInfo/qType",

                          "id": "/qInfo/qId",

                          "lb": "/qListObjectDef",

                          "hc": "/qHyperCubeDef" } } } ] }

The response is:

{

    "jsonrpc": "2.0",

    "id": 4,

    "result": {

        "qReturn": {

            "qType": "GenericObject",

            "qHandle": 2,

            "qGenericType": "sheet",

            "qGenericId": "SH02"

        },

        "qInfo": {

            "qId": "SH02",

            "qType": "sheet"

        }

    },

    "change": [

        1,

        2

    ]

}

Thank you!

1 Solution

Accepted Solutions
ErikWetterberg

Hi,

If you want to create a sheet that works in the client it must have some additional data, or your app will not work at all in the client. Check out this thread: Unable to Create Sheets through Qlik Engine or API

Hope this helps

Erik Wetterberg

View solution in original post

2 Replies
ErikWetterberg

Hi,

If you want to create a sheet that works in the client it must have some additional data, or your app will not work at all in the client. Check out this thread: Unable to Create Sheets through Qlik Engine or API

Hope this helps

Erik Wetterberg

moleroalonso
Contributor II
Contributor II
Author

Thank you Erik!