Automatic website import to QB field

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I want to get a data from the product page on Homedepot.com. See below. 
https://www.homedepot.com/p/BRUSH-BEAST-Heavy-Duty-2-Wheeled-Ride-Along-Sulky-SK112/303311202


What I want is to get the pricing imported into one of the fields (id# 15) on my table (ID# bpe9y3ysz). Can somebody please tell me how to do this?

Thanks in advance!
Photo of Sales Info

Sales Info

  • 818 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Is it just this one item? Or are you trying to get a list of SKUs?

The way to get data from another system/website is through their API in most cases. I did some quick googling and Home Depot has an API but you need log in info to access it. An alternative but not as efficient is to essentially scrape the page. Basically you could have a process that opens up the webpage, digs around the actual HTML code that makes it up and grabs the value you want. That method has a lot more holes though and much harder to implement. 

Either way - you'll need some custom coding for either method. 

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

Sales Info

  • 818 Points 500 badge 2x thumb
Chayce Duncan,

Thanks for your response! I need to get the data for a list of SKUs. Can you please show the steps to get through their API and get the data automatically updated into quickbase.

Thanks in advance!
So there isn't really much I can personally do as I don't have access to the Home Depot API.

Here is the link to the Home Depot API that I found: http://developer.homedepot.com/book-page/product-apis

Your first step would be to find out how to register in their developer program and figure out the requirements for their api. I would imagine they would have an API call to pass in SKU's to get product information and current pricing. With that - you can call the Home Depot API and pass that back to Quick Base using API_EditRecord or API_ImportFromCSV calls

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

Cantan Group

  • 112 Points 100 badge 2x thumb
Are you looking to scrape product pages based on some query?  If so you will have to build a custom scraper and use the QB APIs to import it to your table.  Can you send some detail of what you're trying to accomplish?

Cantan Group | Quick Base Dev (contact for custom work at a great rate)
(416) 727-0407 | admin@cantangroup.com
(Edited)