How to use a dynamic value in and API call with invoke url
I am working on a form that will autofill multiple fields based off of a parameter (Case_Number) value that is passed through url. I want to append that value to the endpoint in my API as query so I can grab the corresponding data to that Case_Number to autofill other fields in my form. I was thinking something similar to a JavaScript template literal, but I can't seem to find a way to do this with Deluge. Any suggestions?
- // On load of form, Case_Number will be the unique ID that triggers the autofill of several other fields
- //casenumber = input.Case_Number;
- response = invokeurl
- [
- url :"https://data.wcad.org/resource/rzdy-vxin.json?casenumber=" + input.Case_Number
- type :GET
- connection:"arb_minutes_to_tyler_api"
- ];
- //
- quickRefID = response.getJSON("quickrefid");
- taxYear = response.getJSON("taxyear");
- appellantName = response.getJSON("appellantname");
- appealID = response.getJSON("appealid");
- noticeValue = response.getJSON("fnoticevalue");
- owner = response.getJSON("ownerpartyname");
- propertyType = response.getJSON("propertytypecode");
- legalDescription = response.getJSON("legaldescription");
- appellantAddress1 = response.getJSON("appellantaddress1");
- appellantAddress2 = response.getJSON("appellantaddress2");
- appellantCity = response.getJSON("appellantcity");
- appellantState = response.getJSON("appellantstate");
- appellantZip = response.getJSON("appellantzip");
- typeOfProtest = response.getJSON("appealreasonscode");
- input.PID = response.getJSON("propertyid");
- //
- input.Quick_Ref_ID = quickRefID;
- input.Appeal_Tax_Year = taxYear;
- input.Appellant = appellantName;
- input.Appeal_ID = appealID;
- input.Notice_Value = noticeValue;
- input.Property_Owner = owner;
- input.Property_Type = propertyType;
- input.Legal_Descriprion = legalDescription;
- input.Appellant_Address_1 = appellantAddress1;
- input.Appellant_Address_2 = appellantAddress2;
- input.City = appellantCity;
- input.State = appellantState;
- input.Postal_Code = appellantZip;
- input.Type_of_Protest = typeOfProtest;
- input.PID = input.PID;
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.