Read feedbacks with manual pagination
Reads feedback records in batches to overcome API pagination limits. This example demonstrates how to retrieve data month-by-month and combine the results using UNION to get a complete dataset for a longer period.
This approach is necessary when the total number of records exceeds the API's single-request limit, ensuring all data is captured by iterating through date ranges.
SELECT * INTO #t1 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-01-01', EndTime='2023-02-01');
SELECT * INTO #t2 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-02-01', EndTime='2023-03-01');
SELECT * INTO #t3 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-03-01', EndTime='2023-04-01');
SELECT * INTO #t4 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-04-01', EndTime='2023-05-01');
SELECT * INTO #t5 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-05-01', EndTime='2023-06-01');
SELECT * INTO #t6 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-06-01', EndTime='2023-07-01');
SELECT * INTO #t7 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-07-01', EndTime='2023-08-01');
SELECT * INTO #t8 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-08-01', EndTime='2023-09-01');
SELECT * INTO #t9 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-09-01', EndTime='2023-10-01');
SELECT * INTO #t10 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-10-01', EndTime='2023-11-01');
SELECT * INTO #t11 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-11-01', EndTime='2023-12-01');
SELECT * INTO #t12 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-12-01', EndTime='2024-01-01');
SELECT * FROM #t1 UNION
SELECT * FROM #t2 UNION
SELECT * FROM #t3 UNION
SELECT * FROM #t4 UNION
SELECT * FROM #t5 UNION
SELECT * FROM #t6 UNION
SELECT * FROM #t7 UNION
SELECT * FROM #t8 UNION
SELECT * FROM #t9 UNION
SELECT * FROM #t10 UNION
SELECT * FROM #t11 UNION
SELECT * FROM #t12;