https://community.qlik.com/t5/Connectivity-Data-Prep/Json-to-Table-connector/m-p/2416538#M13362 <P>Hi,</P> <P>I've established a web connection for an API that produces the following output:</P> <P>{<BR />"totalevents": 28,<BR />"events": [<BR />{<BR />"eventid": 111111,<BR />"clientid": 11111,<BR />"goodafter": "2023-11-14T16:00:00-08:00",<BR />"isactive": true,<BR />"ishybridevent": false<BR />}<BR />]<BR />}<BR /><BR /></P> <P>However, when I utilize the JsonToTable function for this connection, it only retrieves the first row, resulting in a table with a single row. In contrast, accessing the raw data allows me to pull the entire dataset. The output is in proper JSON format. Does anyone have a solution for this issue?</P> Thu, 08 Feb 2024 10:47:21 GMT Saeedarb 2024-02-08T10:47:21Z https://community.qlik.com/t5/Connectivity-Data-Prep/Json-to-Table-connector/m-p/2416538#M13362 <P>Hi,</P> <P>I've established a web connection for an API that produces the following output:</P> <P>{<BR />"totalevents": 28,<BR />"events": [<BR />{<BR />"eventid": 111111,<BR />"clientid": 11111,<BR />"goodafter": "2023-11-14T16:00:00-08:00",<BR />"isactive": true,<BR />"ishybridevent": false<BR />}<BR />]<BR />}<BR /><BR /></P> <P>However, when I utilize the JsonToTable function for this connection, it only retrieves the first row, resulting in a table with a single row. In contrast, accessing the raw data allows me to pull the entire dataset. The output is in proper JSON format. Does anyone have a solution for this issue?</P> Thu, 08 Feb 2024 10:47:21 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Json-to-Table-connector/m-p/2416538#M13362 Saeedarb 2024-02-08T10:47:21Z