Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
6 years ago

Get an XML result from an API call into a field as a value

I have a formula button that returns the User ID of a user based on their email address.  I'm getting the result in an XML page and want to pass it to a field called User ID. Here's the formula tha...
Formulas and functions
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
6 years ago
Dana - see the below as one way to get the User Id

"javascript: {" & 
  "$.get('" & $urlU & "',function(data,success) {" & 
        "console.log(data);" &
        "var user = data.getElementsByTagName('user')[0].getAttribute('id');" & 
        "console.log(user);" & 
        //"$.get('" & $urlE & "' + user);" & 
  "});" &   
"}"

In this case - I've declared urlU as the getUserInfo API call - then the User Id gets stored in a variable 'user' in the actual JS line. I've commented it out - but the second $.get is where you can set up your Edit Record call and include the user variable as part of the call

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base