Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Specify the index of the table in square brackets: tables[0]
    Your output JSON will present only the first table.

  2. Specify the tab_index value of the table: tables[table.tab_index=0]
    The tables object in the response is an array of table objects. Each table object has an element for tab_index, that corresponds to it’s numerical ID. The list of tables and associated id’s always starts at zero.

  3. Target a specific table object by altering the expression: tables.table[tab_index=0].
    With this expression, you again get only one table, but pay careful attention to the JSON output. The way this example is expressed will result in slightly different output. It’s important to understand completely how your expressed output is formed, as it will impact how you write expressions to map any data points.

Find A Specific Header Value

Write an expression that will return the Due Date.

  1. Filter by header/footer values with the expression: header_footer

  2. Further filter the result by expressing only the key Due Date: header_footer[key='Due Date']

  3. Further filter to get the value: header_footer[key='Due Date'].value

To summarize, the complete expressions finds the header_footer section, filters for a key of Due Date, and outputs the value of that key.

It can be useful to “generalize” your key targets with partial matches and case sensitivity. This is handled with regular expressions. If for example you wanted your lookup to be case insensitive, you would provide a case insensitive pattern. Regex is expressed as key ~> pattern.

  • header_footer[key~>/due date/i].value would match “Due Date”, “due date”, or “dUe dAtE”.