Problem

At AcmeCLI, you need to format an API response into a deterministic, aligned text table.

Task

Implement format_api_output(response_json, query, sort_by, limit).

Input

• response_json: str — JSON string expected to be an array of objects.
• query: str — case-insensitive substring filter applied to name.
• sort_by: str — either 'name' or 'score'.
• limit: int — maximum number of output rows.

Record rules

• Keep only records where id and name are strings.
• score handling:
  • If missing or null, treat as 0.
  • If present, it must be an int (but not bool); otherwise ignore the record.

Sorting

• If sort_by == 'name': sort by name.lower() ascending, then id ascending.
• If sort_by == 'score': sort by score descending, then name.lower() ascending, then id ascending.

Output formatting

• Always output a header line: ID NAME SCORE.
• Use exactly one space between columns.
• Column widths are computed from the header and the emitted rows (after filtering, sorting, and limiting).
• ID and NAME are left-aligned; SCORE is right-aligned.

Examples

1. response_json='[{"id":"1","name":"A","score":"9"},{"id":"2","name":"A","score":9}]', query='', sort_by='score', limit=10 Output: ID NAME SCORE 2 A 9 Explanation: the first record is ignored because score is a string.

2. response_json='[{"id":"x","name":"Echo"},{"id":"y","name":"echelon","score":0},{"id":"z","name":"Other","score":5}]', query='ech', sort_by='name', limit=10 Output: ID NAME SCORE x Echo 0 y echelon 0 Explanation: filter keeps Echo/echelon; sort is case-insensitive by name.

Constraints

• 0 <= len(response_json) <= 2 * 10^6
• 0 <= n <= 2 * 10^5 (records in parsed array)
• 0 <= limit <= n
• sort_by in {'name','score'}