API "Base > Rows > List Rows" does not return fields with empty values in the first row

[eugene]

Hi, Seatable,

As mentioned in the title,
the API “List Rows” does not return fields that are empty in the first row.

• “List Rows” has this issue. https://api.seatable.io/reference/list-rows
• “List Rows (with SQL)” is OK

This is the case even if the rows after the second one are not empty.
Can you please fix this?

Thank you.

“List Rows” ignores fields (“group” and “what”).

[daniel.pan]

@eugene

the API “List Rows” does not return fields that are empty in the first row.

This is a designed behaviour. If there is no content, the corresponding cell is empty and will not be listed via List Rows API.

For SQL, it is specially designed to meet SQL standard.