SPFx related issue

Bhargava Ch

6y2k

is it possible to send multiple queries using CAML queries from SP-Pnp-JS inbatch?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhargava Ch6y ago
Thanks
0
Sagar Pardeshi6y ago
Hi Bhargava,

I am just given the example.
0
Bhargava Ch6y ago
Thanks a lot Sagar,

I knew this option but I would like to have batching and not the pagination.
0

Sagar Pardeshi6y ago

Hi Bhargava,

Yes,It's possible you can pass the CAML query from SP-PnP

const xml = "2";

const q: CamlQuery = {     ViewXml: xml, };

 pnp.sp.web.lists.getByTitle("SPPnPJSExampleList").getItemsByCAMLQuery(q).then((r: any[]) => {

    console.log(JSON.stringify(r, null, 4));

     const last = r[r.length - 1];

     // build a query to get the next page

 const q2: CamlQuery = {

     ListItemCollectionPosition: { PagingInfo: `Paged=TRUE&p_ID=${last.ID}&p_Title=${last.Title}` },

        ViewXml: xml,

};

  // run the next page query

  pnp.sp.web.lists.getByTitle("SPPnPJSExampleList").getItemsByCAMLQuery(q2).then((r2: any[]) => {

       console.log(JSON.stringify(r2, null, 4));

        process.exit(0);

});

 }).catch(console.error);

Bhargava Ch6y ago
Hi Roshni,

Thanks for reply, but it was based on the JSOM model, I am searching it in sp-pnp-js like below.
https://www.c-sharpcorner.com/article/batch-query-using-sp-pnp-js/
0
Roshni Gandhi6y ago
Hi Bhargava,

I think below link may usefull for you
https://social.msdn.microsoft.com/Forums/office/en-US/a5af127e-c579-4c28-9fd5-e37650d7ab88/update-multiple-items-using-caml-query?forum=sharepointdevelopment
0
Bhargava Ch6y ago
Hi Sagra,

Thanks for reply, I knew the below cases and if possible can you please check below link
https://www.c-sharpcorner.com/article/batch-query-using-sp-pnp-js/
it is with out CAML query, so I would like to create same using CAML query.

So can you please let me know is it possible to have the same using CAML query?

Thanks,
Bhargava Channooru
0
Sagar Pardeshi6y ago
The simplest way is to use PnPJS library for that purpose. $batch itself is a bit complicated when it comes to response parsing, etc. however PnPJS library hides all complicated logic inside.
This is how you can query multiple lists in one HTTP request with PnPJS:
```
import { sp } from "@pnp/sp";
```
```
  const batch = sp.web.createBatch(); 
```
```
 sp.web.getList("sites//Lists/List1").items.inBatch(batch).get() .then(items1 => {  
```
```
   console.log(items1);  });
```
```
 sp.web.getList("sites//Lists/List2").items.inBatch(batch).get() .then(items2 => {
```
```
     console.log(items2); 
```
```
 });;
```
```
 // this line executes actual HTTP request to $batch endpoint
```
```
 batch.execute() .then(data => { 
```
```
// at this point all requests will be completed   
```
```
  console.log('done'); });
```
1. I recommend you to install Chrome SP Editor add-in.
2. Then open your SharePoint site with targeted lists.
3. Then Open developer tools.
4. Go to the SharePoint tab and select PnPJS console in the left menu.
5. Copy\Paste my code (don't forget to fix urls) and hit CTRL+D.
6. In a console you will see the result.
0