Forum Discussion
EvanMartinez
8 years agoModerator
You would want to include your actual trigger conditions for the webhook, as my example didn't have any triggers or endpoints in place. Looking at your current set up that would create one record in the end point table from one record being added. what you just need to do is for each record being created it needs to be broken out into its own line without a comma like below:
"[Date Created]","[Project Name]","[CheckBox1]", "[Record ID#]","First Record Created by Webhook"
"[Date Created]","[Project Name]","[CheckBox2]", "[Record ID#]","Second Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox3]", "[Record ID#]","Third Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox4]", "[Record ID#]","Fourth Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox5]", "[Record ID#]"," Fifth Record Created By Webhook"
What it then does is it reads each line like a line in a CSV file, with the commas telling it the break between each field. So this example would create 5 records containing the 5 pieces of information in each line of text without a comma at the end and then each lines goes into the fields in the destination table indicated in the clist at the bottom, in the order indicated. So in my example
<clist>6.7.8.9.10</clist>
Date Created goes into field 6, Project Name goes into field 7, Checkbox1 goes into field 8, etc. Then when it has gone through all 5 fields and it reaches that next line it starts over at field 6 again.
"[Date Created]","[Project Name]","[CheckBox1]", "[Record ID#]","First Record Created by Webhook"
"[Date Created]","[Project Name]","[CheckBox2]", "[Record ID#]","Second Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox3]", "[Record ID#]","Third Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox4]", "[Record ID#]","Fourth Record Created By Webhook"
"[Date Created]","[Project Name]","[CheckBox5]", "[Record ID#]"," Fifth Record Created By Webhook"
What it then does is it reads each line like a line in a CSV file, with the commas telling it the break between each field. So this example would create 5 records containing the 5 pieces of information in each line of text without a comma at the end and then each lines goes into the fields in the destination table indicated in the clist at the bottom, in the order indicated. So in my example
<clist>6.7.8.9.10</clist>
Date Created goes into field 6, Project Name goes into field 7, Checkbox1 goes into field 8, etc. Then when it has gone through all 5 fields and it reaches that next line it starts over at field 6 again.