• Edward Berwick
  • NEWBIE
  • 10 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hi,

I'm new to this API calling etc. I want to retrieve Address and other company information based upon the Salesforce Account Name. The External API I'm using is Duedil which holds mainly UK Company information. Based upon simply the name of a company e.g.  where Account Name =  'Arjo Fine Paper'

for a URL button

http://api.duedil.com/open/search?q={!Account.Name}&api_key=MY_API_KEY (they're free upon request at the website)

the response is 

{"response":{"pagination":"http:\/\/api.duedil.com\/open\/search?query=Arjo+Fine+Paper&total_results=3&limit=5&last_result=1","data":[{"company_number":"00961440","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/00961440.json"},{"company_number":"01870033","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Export Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/01870033.json"},{"company_number":"00683415","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Holdings Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/00683415.json"}]}}

I would like to simply parse the results in this output in Bold to 

https://www.duedil.com/company/00961440

then the user can potentially determine is the name they entered a known UK company (according to Duedil at least).

BTW Duedil intend to cover other countries in future.






Hi,

I'm new to this API calling etc. I want to retrieve Address and other company information based upon the Salesforce Account Name. The External API I'm using is Duedil which holds mainly UK Company information. Based upon simply the name of a company e.g.  where Account Name =  'Arjo Fine Paper'

for a URL button

http://api.duedil.com/open/search?q={!Account.Name}&api_key=MY_API_KEY (they're free upon request at the website)

the response is 

{"response":{"pagination":"http:\/\/api.duedil.com\/open\/search?query=Arjo+Fine+Paper&total_results=3&limit=5&last_result=1","data":[{"company_number":"00961440","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/00961440.json"},{"company_number":"01870033","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Export Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/01870033.json"},{"company_number":"00683415","locale":"United Kingdom","name":"Arjo Wiggins Fine Papers Holdings Limited","uri":"http:\/\/api.duedil.com\/open\/uk\/company\/00683415.json"}]}}

I would like to simply parse the results in this output in Bold to 

https://www.duedil.com/company/00961440

then the user can potentially determine is the name they entered a known UK company (according to Duedil at least).

BTW Duedil intend to cover other countries in future.