Select or eliminate cells
You can select specified rows or columns of a spreadsheet with the row and column parameters.
[Public datalake] Spreadsheet
curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&column=1&row=1&row=2&row=3&row=4&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"
The value of these parameters corresponds to the value of the virtual aspects xbrl28:SpreadsheetRow and xbrl28:SpreadsheetColumn associated with each cell in the spreadsheet output. The topmost, leftmost cell has coordinates (1,1), that is counting begins with 1.
You can also choose to automatically remove rows and columns that are empty with the eliminate parameter.
[Public datalake] Spreadsheet
curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&language=ja&eliminate=true&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"
Elimination does not reassign row and column numbers, that is, cells keep the coordinates assigned before elimination.
When you eliminate, you can specify a threshold of elimination between 0 and 100. If the threshold is set to 0 (which is the default), only fully empty rows and columns are eliminated. With 100, everything is eliminated. With a value inbetween, say, 50, the rows and columns with less than 50% of filled cells are eliminated. In this case, this eliminates the third column, which is a period for which only a value is reported from a previous year.
[Public datalake] Spreadsheet
curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&language=ja&eliminate=true&elimination-threshold=50&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"