agaitan026 Posts - Answer Overflow

agaitan026

Explore posts from servers

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

im trying const response = await axios.post( 'https://alexis-gaitan-s-workspace-r0aiag.us-east-1.xata.sh/db/dbsnetworkdb:main/tables/usuarios/query', but its showing only max 1000 results, but i have like 10000

7 replies

XXata

•Created by agaitan026 on 6/15/2024 in #help

summarize columns linked table

"records": [
    {
      "id": "1",
      "name": "MW305R Router Inalámbrico N de 300Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "qty_available": 5,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "name": "MS105G Switch de escritorio de 5 puertos 10/100 / 1,000 Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "qty_available": 0,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T14:18:49.988908+00:00",
              "version": 5
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}

"records": [
    {
      "id": "1",
      "name": "MW305R Router Inalámbrico N de 300Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "qty_available": 5,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "name": "MS105G Switch de escritorio de 5 puertos 10/100 / 1,000 Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "qty_available": 0,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T14:18:49.988908+00:00",
              "version": 5
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}