Forum Discussion

VenuVaddella's avatar
VenuVaddella
Qrew Trainee
6 years ago

I have an URL(API) and it returns a number value and i want to store response into a field.

Please copy paste the below url in the browser and you can see the map {"rate":0}.  http://solgenservices.com/api/QB/taxrate?street=5102 S Coulee Vista Dr&city=Kennewick&zipcode=99338 This is my...
Quickbase Automations
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
6 years ago
You can toss some Javascript into a formula-url - and if your solgen services site accepts https request doing something like this: 

var text map = http://solgenservices.com/api/QB/taxrate?street="&[Address: Street 1]&
"&city="&[Address: City]&
"&state="&[Address: State/Region]&
"&zipcode="&[Address: Postal Code]


NOTE: The syntax below is a rough outline - it will need to be tweaked to work in an actual formula

javascript: {
$.get('" & $map & "').then(function(data,success){
//parse the response here
$.get('" //do an api_editRecord call to Quick Base with your response "'); }

Basically do a GET request to your map service - within the GET call - work out the response in the .then function and then chain another GET call to store that value into Quick Base

Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
6 years ago
I'm happy to help with the Quick Base side - but for full disclosure I'm having a hard time trying to pull anything from your map and nothing loads for me when I go to the link

From a Quick Base standpoint though - the code looks like this: 

var text map = "http://solgenservices.com/api/QB/taxrate?street="&[Address: Street 1]&
"&city="&[Address: City]&
"&state="&[Address: State/Region]&
"&zipcode="&[Address: Postal Code];

"javascript: {" & 
"$.get('" & $map & "').then(function(data,success){" & 
//You'll have to do your own coding here - if you can do a GET request against your mapping API - you'll need to parse the response here - so you can pass it into the Edit Record below
var mapValue = "";
     $.get('https//yourealm.quickbase.com/db/bpn3pd7fz?a=API_EditRecord&apptoken=enteryourtoken&rid=" & [Record ID#] & "&_fid_184=' + mapValue);" & 
"});" & 
"}"

Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base