Styjun

GPLv3 forces us to make code available, but to who?

Sending mail to the Professor for PhD, after seeing his tweet

How dangerous is a very out-of-true disc brake wheel?

Why has Speaker Pelosi been so hesitant to impeach President Trump?

Confusion regarding control system of Mars Rover?

Caro-Kann c4-c5 push

SOQL injection vulnerability issue

Could Boris Johnson face criminal charges for illegally proroguing Parliament?

Is there a way to remove Smite from a weapon?

麦酒 (ばくしゅ) for "beer"

Why such a singular place for bird watching?

Citing CPLEX 12.9

How can Germany increase investments in Russia while EU economic sanctions against Russia are still in place?

Airport Security - advanced check, 4th amendment breach

Can I cast Death Ward on additional creatures without causing previous castings to end?

Is there an in-universe explanation of how Frodo's arrival in Valinor was recorded in the Red Book?

Can an untrusted VPN client monitor my network activity?

Did Joe Biden "stop a prosecution" into his son in Ukraine? And did he brag about stopping the prosecution?

Duck, duck, gone!

Would an object shot from earth fall into the sun?

Wondering why they used ultrafast diodes in a 50 or 60Hz bridge?

A word that refers to saying something in an attempt to anger or embarrass someone into doing something that they don’t want to do?

Could the Queen overturn the UK Supreme Court ruling regarding prorogation of Parliament?

Looking for circuit board material that can be dissolved

SQL Server Woocommerce API connection gives NULL when getting products, works fine with orders

SQL Client for Mac OS X that works with MS SQL ServerGet list of databases from SQL ServerHow can I get column names from a table in SQL Server?OR is not supported with CASE Statement in SQL ServerSQL Server - inner join when updatingPosting to tumblr using API v2 on iOS returning errorUsing Magento REST APIAuthintication Error in Ionic WooCommerce using AngularWhen i try to authenticate oauth1 rest api returnse Invalide_signature errorwoocommerce get API for order products store name

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

1

I am trying to set up a connection between a external SQL Server Database and the Woocommerce API.

The goal is to communicate between 2 websites, where they exchange data, the external website will send a POST request to Woocommerce to create a product, then GET the list of products to select the latest added one and then uses that product ID to create a add to cart link which will put the product into the Cart.

Now here is my code :

 DECLARE @contentType NVARCHAR(64);
 DECLARE @ret INT;
 DECLARE @responseText NVARCHAR(4000);
 DECLARE @status NVARCHAR(32);
 DECLARE @statusText NVARCHAR(32);
 DECLARE @token INT;
 DECLARE @url NVARCHAR(256);

 SET @contentType = 'application/json';

 set @url = 'https://mywebsite.com/wp-json/wc/v3/products/?consumer_key=mykey&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1458225139&oauth_nonce=nVq4rX&consumer_secret=mysecret&oauth_signature=kzoVx%20VYSWlLbRpi3f8222222%3D'


 EXEC @ret = sp_OACreate 'WinHttp.WinHttpRequest.5.1', @token OUT;

 EXEC @ret = sp_OAMethod @token, 'open', NULL, 'GET', @url, 'false';
 EXEC @ret = sp_OAMethod @token, 'setRequestHeader', NULL, 'Content-type', @contentType;
 EXEC @ret = sp_OAMethod @token, 'send', NULL;

 EXEC @ret = sp_OAGetProperty @token, 'status', @status OUT;
 EXEC @ret = sp_OAGetProperty @token, 'statusText', @statusText OUT;
 EXEC @ret = sp_OAGetProperty @token, 'responseText', @responseText OUT;

 EXEC @ret = sp_OADestroy @token;

 RETURN @responseText;

When i return the status i get 200, which to my knowledge is the desirable status.

But when i return responseText i get null.

The infuriating part is when i replace products with orders i get a result as expected, but when getting the products it keeps saying NULL.

Please help, because i am losing the last few hairs on my head.

Also my boss insists on doing it by SQL Server..

sql-server api woocommerce

share|improve this question

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

add a comment
 | 

1

I am trying to set up a connection between a external SQL Server Database and the Woocommerce API.

The goal is to communicate between 2 websites, where they exchange data, the external website will send a POST request to Woocommerce to create a product, then GET the list of products to select the latest added one and then uses that product ID to create a add to cart link which will put the product into the Cart.

Now here is my code :

 DECLARE @contentType NVARCHAR(64);
 DECLARE @ret INT;
 DECLARE @responseText NVARCHAR(4000);
 DECLARE @status NVARCHAR(32);
 DECLARE @statusText NVARCHAR(32);
 DECLARE @token INT;
 DECLARE @url NVARCHAR(256);

 SET @contentType = 'application/json';

 set @url = 'https://mywebsite.com/wp-json/wc/v3/products/?consumer_key=mykey&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1458225139&oauth_nonce=nVq4rX&consumer_secret=mysecret&oauth_signature=kzoVx%20VYSWlLbRpi3f8222222%3D'


 EXEC @ret = sp_OACreate 'WinHttp.WinHttpRequest.5.1', @token OUT;

 EXEC @ret = sp_OAMethod @token, 'open', NULL, 'GET', @url, 'false';
 EXEC @ret = sp_OAMethod @token, 'setRequestHeader', NULL, 'Content-type', @contentType;
 EXEC @ret = sp_OAMethod @token, 'send', NULL;

 EXEC @ret = sp_OAGetProperty @token, 'status', @status OUT;
 EXEC @ret = sp_OAGetProperty @token, 'statusText', @statusText OUT;
 EXEC @ret = sp_OAGetProperty @token, 'responseText', @responseText OUT;

 EXEC @ret = sp_OADestroy @token;

 RETURN @responseText;

When i return the status i get 200, which to my knowledge is the desirable status.

But when i return responseText i get null.

The infuriating part is when i replace products with orders i get a result as expected, but when getting the products it keeps saying NULL.

Please help, because i am losing the last few hairs on my head.

Also my boss insists on doing it by SQL Server..

sql-server api woocommerce

share|improve this question

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

add a comment
 | 

I am trying to set up a connection between a external SQL Server Database and the Woocommerce API.

The goal is to communicate between 2 websites, where they exchange data, the external website will send a POST request to Woocommerce to create a product, then GET the list of products to select the latest added one and then uses that product ID to create a add to cart link which will put the product into the Cart.

Now here is my code :

 DECLARE @contentType NVARCHAR(64);
 DECLARE @ret INT;
 DECLARE @responseText NVARCHAR(4000);
 DECLARE @status NVARCHAR(32);
 DECLARE @statusText NVARCHAR(32);
 DECLARE @token INT;
 DECLARE @url NVARCHAR(256);

 SET @contentType = 'application/json';

 set @url = 'https://mywebsite.com/wp-json/wc/v3/products/?consumer_key=mykey&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1458225139&oauth_nonce=nVq4rX&consumer_secret=mysecret&oauth_signature=kzoVx%20VYSWlLbRpi3f8222222%3D'


 EXEC @ret = sp_OACreate 'WinHttp.WinHttpRequest.5.1', @token OUT;

 EXEC @ret = sp_OAMethod @token, 'open', NULL, 'GET', @url, 'false';
 EXEC @ret = sp_OAMethod @token, 'setRequestHeader', NULL, 'Content-type', @contentType;
 EXEC @ret = sp_OAMethod @token, 'send', NULL;

 EXEC @ret = sp_OAGetProperty @token, 'status', @status OUT;
 EXEC @ret = sp_OAGetProperty @token, 'statusText', @statusText OUT;
 EXEC @ret = sp_OAGetProperty @token, 'responseText', @responseText OUT;

 EXEC @ret = sp_OADestroy @token;

 RETURN @responseText;

When i return the status i get 200, which to my knowledge is the desirable status.

But when i return responseText i get null.

The infuriating part is when i replace products with orders i get a result as expected, but when getting the products it keeps saying NULL.

Please help, because i am losing the last few hairs on my head.

Also my boss insists on doing it by SQL Server..

sql-server api woocommerce

share|improve this question

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

 DECLARE @contentType NVARCHAR(64);
 DECLARE @ret INT;
 DECLARE @responseText NVARCHAR(4000);
 DECLARE @status NVARCHAR(32);
 DECLARE @statusText NVARCHAR(32);
 DECLARE @token INT;
 DECLARE @url NVARCHAR(256);

 SET @contentType = 'application/json';

 set @url = 'https://mywebsite.com/wp-json/wc/v3/products/?consumer_key=mykey&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1458225139&oauth_nonce=nVq4rX&consumer_secret=mysecret&oauth_signature=kzoVx%20VYSWlLbRpi3f8222222%3D'


 EXEC @ret = sp_OACreate 'WinHttp.WinHttpRequest.5.1', @token OUT;

 EXEC @ret = sp_OAMethod @token, 'open', NULL, 'GET', @url, 'false';
 EXEC @ret = sp_OAMethod @token, 'setRequestHeader', NULL, 'Content-type', @contentType;
 EXEC @ret = sp_OAMethod @token, 'send', NULL;

 EXEC @ret = sp_OAGetProperty @token, 'status', @status OUT;
 EXEC @ret = sp_OAGetProperty @token, 'statusText', @statusText OUT;
 EXEC @ret = sp_OAGetProperty @token, 'responseText', @responseText OUT;

 EXEC @ret = sp_OADestroy @token;

 RETURN @responseText;

sql-server api woocommerce

sql-server api woocommerce

share|improve this question

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

share|improve this question

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

edited Mar 30 at 7:51

marc_s

605k137137 gold badges11591159 silver badges12921292 bronze badges

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge

asked Mar 28 at 20:53

Handler03Handler03

611 bronze badge