How can use the SharePoint REST API to retrieve data from multiple lists in one time by making multiple GET requests in a single API call?

 

                        

You can do this by concatenating the URLs of the different lists you want to retrieve data from and making one GET request to that combined URL.

You can also use the $expand query parameter to retrieve data from multiple lists related to a specific list in a single GET request.

For example, if you want to retrieve data from lists A, B, C, and D in one GET request, you can make a GET request to the following URL:

            https://your-site-url/_api/web/lists/getbytitle('A')/items?$expand=B,C,D

This will retrieve all items from list A, and also include any related items from lists B, C, and D in the response.

Another way to retrieve the data from multiple list in one time is by using the $batch request. This allows you to group multiple requests together and send them as a single batch request. The server will process all the requests in the batch and return the responses in a single response.

For more information on how to use the SharePoint REST API, you can refer to the official documentation: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest