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
Solved

How to create Web Service by API

Posted on 2015-02-18
1
98 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
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

809 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