• Replies 10 replies
  • Subscribers 0 subscribers
  • Views 33 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

How to get data of all columns of an isheet item?

Ha Nguyen Danh
27231

HighQ Api provide an api to get an  iSheet item by item id, but this will get the iSheet item by an iSheet View (use the Default View if the isheet view id not specified).

With this one, I can only get all data (all column data) of an isheet item if I have an iSheet View that is configured to have all columns of the iSheet.

Is there a way that I can get the iSheet item with all of it column data without preparing a iSheet View with all the columns?

 

 

Regards,

Ha Nguyen

Parents

  • Ha Nguyen Danh, you don't need a sys. admin token if you are only after all columns of data in an isheet view, e.g.

    api/14/isheet/9999/items?sheetviewid=9999&offset=0&limit=1000&allColumnRequired=true

    with a non- sys admin token it returns all isheet column data, i.e. including columns not defined in the view. You'll still need a view to access isheet data for normal users, however, including allColumnRequired means you can get all the data for each row, and not limited to what that view exposes (columns).

    If you are a sys. admin token, then you can use isIgnoreView=true to essential access the isheet without a view, accessing all rows and all columns.

    I believe this is the behaviour, though I have only began looking at it today after our instance was upgraded yesterday.

    Andrew

    NOTE: These url parameters ARE case-sensitive! Passing isignoreview or allcolumnrequired will result in them being ignored.

Reply

  • Ha Nguyen Danh, you don't need a sys. admin token if you are only after all columns of data in an isheet view, e.g.

    api/14/isheet/9999/items?sheetviewid=9999&offset=0&limit=1000&allColumnRequired=true

    with a non- sys admin token it returns all isheet column data, i.e. including columns not defined in the view. You'll still need a view to access isheet data for normal users, however, including allColumnRequired means you can get all the data for each row, and not limited to what that view exposes (columns).

    If you are a sys. admin token, then you can use isIgnoreView=true to essential access the isheet without a view, accessing all rows and all columns.

    I believe this is the behaviour, though I have only began looking at it today after our instance was upgraded yesterday.

    Andrew

    NOTE: These url parameters ARE case-sensitive! Passing isignoreview or allcolumnrequired will result in them being ignored.

Children
No Data