Solved

How to create Web Service by API

Posted on 2015-02-18
1
92 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

To properly understand GitHub, let’s divide it into two words ‘Git’ and ‘Hub’. Git is basically a ‘Distribution Version Control’ (DVC) and ‘Source Code Management’ (SCM) system widely used by software programmers while Hub means the efficient centre…
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now