How to connect loop data to pdfgeneratorapi ?

Ask the community
,
1

I’m generating PDF by using https://pdfgeneratorapi.com/ .
Now I can show data one by one using this code.Can any one give me suggestion how can show all data with loop or any other way?This is the template I’ve created .

This below photos showing my template from pdfgenerator .

983×190 8.91 KB

This is the code I’m using to generate PDF

let communicationWay1=[
{0:"dim"},
{1:"kal"}
];
let cstomerExpence1=[
{0:"dim"},
{1:"kal"}
];
let title="test";
let names="test";
let phone="test";
let email="test";
let maritalStatus="test";
let city="test";
let other="test";

 const result = await wixData.query(collection)
 .eq('main_user_email', $w('#mainE').text)
         .find()
    .then( (results) => {
 if (results.totalCount>0) {
                    count=1;
 // title=results.items[1].title;
                        names=results.items[0].names;
                        email=results.items[0].emial;
                        phone=results.items[0].phone;
                        maritalStatus=results.items[0].maritalStatus;
                        city=results.items[0].city;
                        other=results.items[0].cousterExpenses_other;                       
                        title=results.items[0].title;
 
                        communicationWay=results.items[0].communicationWay;
                        cstomerExpence=results.items[0].cstomerExpence;

                }
 if (results.totalCount>1) {              
                        names1=results.items[1].names;
                        email1=results.items[1].emial;
                        phone1=results.items[1].phone;
                        maritalStatus1=results.items[1].maritalStatus;
                        city1=results.items[1].city;
                        other1=results.items[1].cousterExpenses_other;                      
                        title1=results.items[1].title;
                        communicationWay1=results.items[1].communicationWay;
                        cstomerExpence1=results.items[1].cstomerExpence;
                }
 
    } )
    .catch( (err) => {
      console.log(err);
    } );
 // Add your code for this event here:  
 const pdfUrl = await getPdfUrl
 ({title,names,email,phone,city,maritalStatus,other,communicationWay,cstomerExpence,title1,
  names1,email1,phone1,city1,maritalStatus1,other1,communicationWay1,cstomerExpence1   
    });
if (count===0) {    $w("#text21").show();}
else{        $w("#downloadButton").link=wixLocation.to(pdfUrl);}   

///BELOW CODE IS BACKEND CODE/JSW CODE
//Also I want to open pdf in new tab. I know "_black" method can be used to open a new //tab.But I'm not sure how to add it with the url
 
import PDFGeneratorAPI from 'pdf-generator-api'

const apiKey = 'MYKEY';
const apiSecret = 'MYAPISECRET';

const baseUrl = 'https://us1.pdfgeneratorapi.com/api/v3/';
const workspace = "HELLO@gmail.com";
const templateID = "MYTEMPLATEID";

let Client = new PDFGeneratorAPI(apiKey, apiSecret)
Client.setBaseUrl(baseUrl)
Client.setWorkspace(workspace)

export async function getPdfUrl(data) {
 const {response} = await Client.output(templateID, data, undefined, undefined, {output: 'url'})
 return response
}