Forum Discussion

ParkerSmith's avatar
ParkerSmith
Qrew Trainee
6 years ago

Webmerge URL & Bad Sign-In Ticket

I am trying to use Quick Base -> Zapier -> Webmerge for generating quote/invoice documents. I've gotten as far as merging data, but the URL I'm sending will not show API_GenResultsTable I need. It should be populated with a table of child records relative to parent record. This is the rendering when merged as PDF:




The merge field in Webmerge template is:
{smarty_curl($report_url) nofilter}

The $report_url variable is populated via Zapier with data originating from Quick Base. My Quick Base-originated URL is the following:

URLRoot() & "db/" & [Child Table Dbid]
& "?a=API_GenResultsTable&query={'219'.XEX.'1'}AND{'111'.EX.'" & [Record ID#] & "'}AND&clist=351.399.48.47.45&_fid_111=" & URLEncode([Case Number]) & "&usertoken=" & [webhook-usertoken] &
"&apptoken=" & [AppToken - Zapier]

The strange thing is it works for another Quick Base app that I'm using. I've been stuck on trying to pick apart the differences in how I set it up and I can't figure it out.

I haven't had a lot of luck with the Quick Base forums so hopefully someone can help out this time.

Thanks,
Parker