I’m converting the code into json using sql sp_OAMethod
Here is the code:
EXEC @ret = sp_OACreate ‘MSXML2.ServerXMLHTTP’, @token OUT
SET @url = ‘https://vindecoder.p.rapidapi.com/decode_vin?vin=4F2YU09161KM33122’;
EXEC @ret = sp_OAMethod @token, ‘Open’, null, ‘post’, @url, ‘false’
EXEC @ret = sp_OAMethod @token, ‘setRequestHeader’, NULL,‘x-rapidapi-host’, 'vindecoder.p.rapidapi.com’
EXEC @ret = sp_OAMethod @token, ‘setRequestHeader’, NULL,‘x-rapidapi-key’, '<<fill api key>>'
EXEC @ret = sp_OAMethod @token, ‘setRequestHeader’, NULL, ‘Content-Type’, @contentType;
EXEC @ret =sp_OAMethod @token, ‘get’, @JSON OUTPUT
Everything ok till last instruction
What am i doing wrong
Assistence will be much apreciated
아래에 의견을 추가하고 토론에 참여하세요.