Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
it is possible to use the import from CSV API in a webhook to create any number of records in a single webhook as long as they are all being created in the same table.
Here is an example of creating 5 records. If that first webhook that you have was reduced to just 1, you would be still at 6, so still a problem. So the only other idea i have is to trigger one of the 5 webhooks off the table where the records are being created in, so that it's sort of a daily chain. The limit is 5 "per table".
<qdbapi>
<usertoken>bxv4tx_bjix_8csgf2bk9smkgc5igppzvgv53r</usertoken>
<records_csv>
%RepeatOn%
"[Last Modified By]","Client Name","[old.Client Name]", "[Client Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Site Name","[old.Site Name]", "[Site Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contact Name","[old.Contact Name]", "[Contact Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contract Name","[old.Contract Name]", "[Contract Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contract Type","[old.Contract Type]", "[Contract Type]", "CO","[Record ID#]","[Record ID#]"
%RepeatOff%
</records_csv>
<clist>6.7.8.9.10.11.14</clist>
</qdbapi>
Here is an example of creating 5 records. If that first webhook that you have was reduced to just 1, you would be still at 6, so still a problem. So the only other idea i have is to trigger one of the 5 webhooks off the table where the records are being created in, so that it's sort of a daily chain. The limit is 5 "per table".
<qdbapi>
<usertoken>bxv4tx_bjix_8csgf2bk9smkgc5igppzvgv53r</usertoken>
<records_csv>
%RepeatOn%
"[Last Modified By]","Client Name","[old.Client Name]", "[Client Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Site Name","[old.Site Name]", "[Site Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contact Name","[old.Contact Name]", "[Contact Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contract Name","[old.Contract Name]", "[Contract Name]", "CO","[Record ID#]","[Record ID#]"
"[Last Modified By]","Contract Type","[old.Contract Type]", "[Contract Type]", "CO","[Record ID#]","[Record ID#]"
%RepeatOff%
</records_csv>
<clist>6.7.8.9.10.11.14</clist>
</qdbapi>
AryehZelczer6
8 years agoQrew Trainee
how would this work if I need info from other tables in this app to populate these new records?