Answered

Export table data through the API

  • 26 May 2021
  • 1 reply
  • 79 views

Badge +1

Is it possible to export table data, including the contents of each cell, using either the web SDK or REST API? I can see it is possible through the UI but I can’t figure out a way to do it programmatically.

I can get back a list of all the widgets but there’s no explicit information about which cell they belong to. I guess it may be possible to calculate which cell each widget belongs to by using the table’s bounds and the widget’s co-ordinates but I haven’t looked into that yet.

 

To give an example I would like to be able to programmatically determine that the “Whiskers” sticky belongs to the “Cats” column and “Names” row.

 

icon

Best answer by Anthony Roux 26 May 2021, 12:24

Hi @Richard Watts-Seale,

 

You are right, it is not possible with the Web SDK and the REST API to export the table in a structured way (like it can be done with a Frame that contains the list of the child). As of today, table is not supported in the SDK, you cannot retrieve the size or the number of cells so I don’t think you will be able to play with coordinates to easily export the element of each cell. You might be able to know by combining the coordinates of the Grid Text of the column and the one of the Row but it doesn’t look easy (I haven’t tried).

View original

1 reply

Userlevel 4
Badge +6

Hi @Richard Watts-Seale,

 

You are right, it is not possible with the Web SDK and the REST API to export the table in a structured way (like it can be done with a Frame that contains the list of the child). As of today, table is not supported in the SDK, you cannot retrieve the size or the number of cells so I don’t think you will be able to play with coordinates to easily export the element of each cell. You might be able to know by combining the coordinates of the Grid Text of the column and the one of the Row but it doesn’t look easy (I haven’t tried).

Reply