?
Solved

How to create Web Service by API

Posted on 2015-02-18
1
Medium Priority
?
108 Views
Last Modified: 2016-02-15
The company is hosting our eCommerce. I need to create SSIS Package retrieving closed orders. I can do it by two ways: either go to website and manually execute CSV Export that creates CSV file or executing in browser API returning closed orders in scramble format. I have API and I need to create if possible Web Service by this API so I can create Web Service Task and retrieve data by the task.

Here is URL I am calling API:

https://mycompany.com/wc-api/v2/orders?consumer_key=KEY&consumer_secret=KEY&created_at_min=2015-02-17&filter%5bpost_status%5d=completed

Since I am new to Web Services probably I looking to the wrong direction.
0
Comment
Question by:Burzhuin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 40626885
Hi,
this kind of URL looks more like a REST service than a classical web service from SSIS. Therefore (and taking your other questions into consideration) I assume a "normal" web client / HTTP request with propper JSON response handling should do the trick.
HTH
Rainer
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question