While querying Sistrix API, in case of no results, API answers on a not unified way. There are two answers possible:
Regularly formatted response
<response>
<method>domain.sichtbarkeitsindex</method>
<info country="de" device="mobile" url="https://www.example.com"/>
<answer>
<sichtbarkeitsindex url="https://www.example.com" date="2024-03-04T00:00:00+01:00" value="0"/>
</answer>
<credits used="1"/>
</response>
or an error message
<response status="fail">
<error error_code="1000" error_message="no result"/>
</response>
The last answers causes empty cell, which breaks authomatic reports and dashboards.
Currently I use a weird workaround to turn empty cells into existing zeros. But - could it be maybe done on STFE side?