Skip to main content
An analyst builds a table of the emissions of 300 companies from their sustainability reports. Cells go wrong in 3 ways. A number is taken from the wrong year’s column. A cell is left empty where the report states the figure on a scanned page. And a cell is filled with a plausible number where the company reports nothing. A client finds one of them, and the whole table is in doubt. This page builds a table in which each cell names its page, and each empty cell says why it is empty.

The run in 4 steps

Send one template with 20 reports

A batch takes 20 addresses and one template. Each report is fetched, and the same fields are filled from each.
Request body of fetch_contents_batch, cut to 2 of 20 items
Replace the 2 placeholders that end in _URL with the address of each report. A label is your own name for a report, such as the company and the year.

Read each cell with its place

Each field of each report comes back with a status. This response is one report, cut to the status, the words, and the place of each field.
Part of the response
The 2 figures for Scope 1 come from one row of one table on page 62, and each names its column. So the figure of 2025 and the figure of the year before cannot change places. The report says nothing about Scope 3, which is absent. “The company does not report Scope 3” is a finding that your table can state. The assurance provider is unread: it could be on a page that was not read, so that cell goes to a person and is not printed as “none”.

Find the restated figures

A report gives last year’s figure again beside this year’s, and sometimes it is no longer the figure that last year’s report stated. Your table has both: scope_1_prior_year from the report of 2025, and scope_1 from the report of 2024. Where the 2 differ, the company restated the figure, and each of the 2 numbers has its page.

Read the table behind a cell

A cell names its row and its column. To show a reader what the row is, read that table from the stored record, cell by cell with its headings. A stored record is read again at no charge.

What the client can check

Know the limits

A model fills the template, and each value is bound to words of the report. A value comes as the report states it: nothing is converted, so “184,200 tCO2e” and “184.2 kt” are 2 strings until your code makes them one unit. A figure that a report shows only in a chart is not read, because the text inside an image is not read on a document that has text of its own. The row and the column of a cell are there where the file has the table’s structure. A table of a scan or of a PDF without structure comes as text, and the cell then has its page and its words. For the calls, see Fill your fields, each with the words it came from and Fetch 20 sources at once and know what came back before you read a word.