Sorted Products By Rating

Product Name
TV 4

Product Rating
1128.83

---

Product Name
TV 2

Product Rating
1015.76

---

Product Name
TV 1

Product Rating
1000

---

Product Name
TV 3

Product Rating
896.53

Imports System
Imports System.Text
Imports System.Net
Imports Newtonsoft.Json

Public Class professional_buyer_api
    Public Class ResponseFields
        Public Property product_name As String
        Public Property product_rating As Double
    End Class

    Public Class ErrorFields
        Public Property cd As String
        Public Property description As String
    End Class

    Protected Sub SendRequest()
        Dim Client As WebClient = New WebClient()
        Dim credentials As String = Convert.ToBase64String(Encoding.ASCII.GetBytes("your_username:your_password"))
        Client.Headers(HttpRequestHeader.Authorization) = String.Format("Basic {0}", credentials)
        Client.Headers(HttpRequestHeader.Accept) = "application/json"
        Client.Headers(HttpRequestHeader.ContentType) = "application/json"
        Client.BaseAddress = "https://gatiosoft.ro/acquestizer.aspx"
        Dim resString As String = ""

        Try
            Dim js As String = "Replace this string with your JSON Request Body string like in the example above on the website"
            Dim reqString As Byte() = Encoding.UTF8.GetBytes(js)
            Dim url As Uri = New Uri(Client.BaseAddress)
            Dim resByte As Byte() = Client.UploadData(url, "post", reqString)
            resString = Encoding.UTF8.GetString(resByte)

            If resString.IndexOf("product_name") > 0 Then
                Dim r As ResponseFields = New ResponseFields()
                r = JsonConvert.DeserializeObject(Of ResponseFields)(resString)
                Console.Write(resString)
            Else
                Dim e As ErrorFields = New ErrorFields()
                e = JsonConvert.DeserializeObject(Of ErrorFields)(resString)
                Console.Write(e.cd)
                Console.Write(e.description)
            End If

            Client.Dispose()
        Catch exception As Exception
            Dim ex As System.Exception = exception
            Console.Write("ERROR: " & resString & ex.Message)
        End Try
    End Sub

    Public Shared Sub Main()
        Dim b As professional_buyer_api = New professional_buyer_api()
        b.SendRequest()
    End Sub
End Class

Sub VBAExcelJson()

Url = "https://gatiosoft.ro/acquestizer.aspx"

JsonRequestBody = "Replace this string with your JSON request string like in example above on the website"

Dim JsonHttp As Object
Set JsonHttp = CreateObject("Microsoft.XMLHTTP")

Dim authUser As String
authUser = "Your Usernmae"
Dim authPass As String
authPass = "Your Password"
    
With JsonHttp
             .Open "POST", Url, False
             .SetRequestHeader "Authorization", "Basic " + EncodeBase64(authUser + ":" + authPass)
             .SetRequestHeader "Content_Type", "application/json"
             .SetRequestHeader "Accept", "application/json"
             .send (JsonRequestBody)
End With

Dim JsonResult As String
JsonResult = JsonHttp.responseText
Cells(1, 1).value = JsonResult

End Sub

Function EncodeBase64(text As String) As String

  Dim arrData() As Byte
  arrData = StrConv(text, vbFromUnicode)

  Dim objXML As MSXML2.DOMDocument60
  Dim objNode As MSXML2.IXMLDOMElement

  Set objXML = New MSXML2.DOMDocument60
  Set objNode = objXML.createElement("b64")

  objNode.DataType = "bin.base64"
  objNode.nodeTypedValue = arrData
  EncodeBase64 = Application.Clean(objNode.text)

  Set objNode = Nothing
  Set objXML = Nothing
End Function

using System;
using System.Text;
using System.Net;
using Newtonsoft.Json;

public class professional_buyer_api
{
   public class ResponseFields
    {
       public string product_name { get; set; }
       public double product_rating { get; set; }
    }
    
    public class ErrorFields
    {
        public string cd { get; set; }
        public string description { get; set; }
    }
	
	
    protected void SendRequest()
    {
        WebClient Client = new WebClient();
        string credentials = Convert.ToBase64String(Encoding.ASCII.GetBytes("your_username:your_password"));
        Client.Headers[HttpRequestHeader.Authorization] = string.Format("Basic {0}", credentials);
        Client.Headers[HttpRequestHeader.Accept] = "application/json";
        Client.Headers[HttpRequestHeader.ContentType] = "application/json";
        Client.BaseAddress = "https://gatiosoft.ro/acquestizer.aspx";
        string resString="";
              
        try
        {
            string js = "Replace this string with your JSON Request Body string like in the example above on the website";
            byte[] reqString = Encoding.UTF8.GetBytes(js);
            Uri url = new Uri(Client.BaseAddress);
            byte[] resByte = Client.UploadData(url, "post", reqString);
            // The resString below is your needed JSON output
            resString = Encoding.UTF8.GetString(resByte);
            if (resString.IndexOf("product_name") > 0)
            {
                ResponseFields r = new ResponseFields();
                r = JsonConvert.DeserializeObject<ResponseFields>(resString);
		Console.Write(resString);
            }
            else
            {
                ErrorFields e = new ErrorFields();
                // Below we find in e.cd (error code) and e.description (error description)
                e = JsonConvert.DeserializeObject<ErrorFields>(resString);
		Console.Write(e.cd);
		Console.Write(e.description);
            }
            Client.Dispose();
        }
        catch (Exception exception)
        {
            System.Exception ex = exception;
            Console.Write("ERROR: " + resString + ex.Message);
        }
    }
              
    public static void Main()
    {
       professional_buyer_api b = new professional_buyer_api(); //instantiate the object
       b.SendRequest();
    }
}

import java.util.Base64;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.ProtocolException;
import java.net.URL;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;


public class Main {
public static void main(String[] args) throws IOException {
    
        String originalInput = "your_username:your_password";
        String credentials = Base64.getEncoder().encodeToString(originalInput.getBytes());
        final String POST_PARAMS = "Replace this string with your JSON request string";
       
        URL obj = new URL("https://gatiosoft.ro/acquestizer.aspx");
        HttpURLConnection postConnection = (HttpURLConnection) obj.openConnection();
        postConnection.setRequestMethod("POST");
        postConnection.setRequestProperty("Authorization", "Basic " + credentials);
        postConnection.setRequestProperty("Content-Type", "application/json");
        postConnection.setRequestProperty("Accept", "application/json");
        postConnection.setDoOutput(true);
        OutputStream os = postConnection.getOutputStream();
        os.write(POST_PARAMS.getBytes());
        os.flush();
        os.close();
        int responseCode = postConnection.getResponseCode();
       
        if (responseCode == 200) { //success
          BufferedReader in = new BufferedReader(new InputStreamReader(
            postConnection.getInputStream()));
          String inputLine;
          StringBuffer response = new StringBuffer();
          while ((inputLine = in .readLine()) != null) {
            response.append(inputLine);
          } in .close();
        // print json string result
          System.out.println(response.toString());
         } 
        else {
           System.out.println("POST NOT WORKED");
    }
  }
}

<?php
ob_start();
  ini_set('display_errors', 1);
  ini_set('display_startup_errors', 1);
  error_reporting(E_ALL);
data_string = 'Replace this string with your JSON request string like in the example above on the website';
$username = 'your_usernmae';
$password = 'your_password';
$hash = base64_encode($username . ':' . $password);
$headers = array(
'Authorization: Basic ' . $hash
);
?><!DOCTYPE html>
<html lang="en">
<head>
  <title>Test TTS API</title>
</head>
<body>
<?php
 $url = "https://gatiosoft.ro/acquestizer.aspx"; // Where you want to post data
 try 
    {
  $ch = curl_init();
  if (FALSE === $ch)
     throw new Exception('failed to initialize');

    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_POST, true);  // Tell cURL you want to post something
    curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string); 
   // Define what you want to post
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    
  //curl_setopt(/* ... */);
  $content = curl_exec($ch);
  
  $info = curl_getinfo($ch);
 
   if (FALSE === $content)
    throw new Exception(curl_error($ch), curl_errno($ch));

  } 
  catch(Exception $e) 
    {
     trigger_error(sprintf(
     'Curl failed with error #%d: %s',
     $e->getCode(), $e->getMessage()),
     E_USER_ERROR);
     }
  echo '<pre>'; print_r($data); echo '</pre>';
  echo '<br />';
  echo http_build_query(array('data' => $data));
  echo '<br /><br />';

 $json = json_encode($data);
echo "<b>JSON Request is:</b>" ."<br />" . $json . "<br />" . "<br />";
  $onlyjson = str_replace("\u0022", '"', $content);

echo "<br />" . "<br />" . "<b>JSON Response From API is:</b>" . "<br />" . $onlyjson . "<br />";?>
</body>
</html>

String URL = "https://gatiosoft.ro/acquestizer.aspx";

String inputs = "Replace this string with your JSON request string";

JSONArray arr = new JSONArray(inputs);

JsonArrayRequest req = new JsonArrayRequest(URL, arr,
new Response.Listener<JSONArray>() {
   @Override
   public void onResponse(JSONArray response) {
       try {
           VolleyLog.v("Response:%n %s", response.toString(4));
       } catch (JSONException e) {
           e.printStackTrace();
       }
   }
}, new Response.ErrorListener() {
   @Override
   public void onErrorResponse(VolleyError error) {
       VolleyLog.e("Error: ", error.getMessage());
   }
})

{
@Override
    public Map<String, String> getHeaders() throws AuthFailureError {
        String credentials = "username" + ":" + "password";
        String base64EncodedCredentials = Base64.encodeToString(credentials.getBytes(), Base64.NO_WRAP);
        HashMap<String, String> headers = new HashMap<>();
        headers.put("Authorization", "Basic " + base64EncodedCredentials);
        headers.put("Content-Type", "application/json");
        headers.put("Accept", "application/json");
        return headers;
    }

};

MyApplication.getInstance().addToRequestQueue(req, "headerRequest");

import Foundation import UIKit import Alamofire

class ViewController: UIViewController {

override func viewDidLoad() {
    super.viewDidLoad()

    let url = URL(string: "https://gatiosoft.ro/acquestizer.aspx")!

    // your credentials encoded in base64
    let username = "Your username"
    let password = "Your password"
    let loginData = String(format: "%@:%@", username, password).
                           data(using: String.Encoding.utf8)!
    let base64LoginData = loginData.base64EncodedString()
    let headers = ["Authorization" : "Basic \(base64LoginData)",
                   "Content-Type": "application/json", "Accept": "application/json"]

    //Prepare paramsBody to send
    let paramsBody: [String: Any] = ["Replace this string with your JSON request string"]

    //Make Request
    Alamofire.request(url, method: .post,parameters: paramsBody, encoding: 
                         URLEncoding.default, headers: headers).responseJSON 
                          { response in print(response)
//get status code
                if let status = response.response?.statusCode {
                    switch(status){
                    case 201:
                        print("Success")
                    default:
                        print("Error with response status: \(status)")
                    }
                }
//get JSON return value
            if let result = response.result.value {
                let JSON = result as! NSDictionary
                print(JSON)
            }

        }

    }
}

import requests
import json
import base64

json_string = 'Replace this string with your JSON request string'
data = json.loads(json_string)

usrPass = b'your_username:your_password'
b64Val = base64.b64encode(usrPass)
b64Val = str(b64Val,'utf-8')

resp = requests.post('https://gatiosoft.ro/acquestizer.aspx', 
                                  headers={"Authorization": "Basic %s" % b64Val,
                                                 'Content-Type': 'application/json', 
                                                 'Accept': 'application/json'}, json=data)
resp_data = resp.json()
print(resp_data)

require 'uri'
require 'net/https'
require 'json'
require 'base64'

class DoHttpsRequest
  def call(url, json)
    uri = URI.parse(url)
    req = Net::HTTP::Post.new(uri.to_s)
    req.body = json.to_json
    req['Content-Type'] = 'application/json'
    req['Accept'] = 'application/json'
    req['Authorization'] =  'Basic ' + Base64.strict_encode64("your_username:your_password")

    response = https(uri).request(req)

    response.body
  end

  private

  def https(uri)
    Net::HTTP.new(uri.host, uri.port).tap do |http|
      http.use_ssl = true
      http.verify_mode = OpenSSL::SSL::VERIFY_NONE
    end
  end
end

url = "https://gatiosoft.ro/acquestizer.aspx"
input_json = 'Replace this string with your JSON request string'

puts DoHttpsRequest.new.call(url, input_json)

var request = require('request');
var auth = 'Basic ' + Buffer.from('your_username' + ':' + 'your_password').toString('base64');
var urlapi = 'https://gatiosoft.ro/acquestizer.aspx';
var jsoninput = 'Replace this string with your JSON request string';

request.post({
        url: urlapi, 
        headers: {
            'Content-Type': 'application/json',
            'Accept': 'application/json',
            'Authorization': auth
        },
        json: jsoninput
    }, function(error, response, body) {
        console.log(response)
    }
);

FUNCTION Professional_Buyer_API()

chttp is un httpRequest
creponse is un httpResponse

sPassWord is a Buffer = "your_username:your_password"
Res_Encode64 is a string = Encode( sPassWord , encodeBASE64)
chttp..Header["Authorization"] = "Basic "+ Res_Encode64
chttp..Header["Accept"] = "application/json" 

chttp..URL = "https://gatiosoft.ro/acquestizer.aspx"
chttp..Method = httpPost
chttp..ContentType = "application/json" 

chttp.Content=
[
 "Replace this string with your JSON input request string"
]

chttp.Content=StringToUTF8(chttp.Content)
creponse = HTTPSend(chttp)


IF ErrorOccurred THEN
	Error(ErrorInfo(errComplet))
	STC_Result..Value="Error"
ELSE
	let vReponseVariant = JSONToVariant("["+creponse.Content+"]")
	STC_Result..Value=creponse.Content
END

<!DOCTYPE html>
<html>
<head>
  <title>Professional Buyer API, Acquestizer</title>
</head>
<body>

//Put the script below before the end of body tag.
   
<script>

let url = 'https://cors-anywhere.herokuapp.com/https://gatiosoft.ro/acquestizer.aspx';
let username = 'your_username';
let password = 'your_password';
var data = "Replace this string with your JSON input string as shown on our website";

var x = new XMLHttpRequest();
    x.open('POST', url);
    x.setRequestHeader('Authorization', 'Basic ' + window.btoa(username + ":" + password));
    x.setRequestHeader('Content-Type', 'application/json');
    x.setRequestHeader('Accept', 'application/json');
    x.onload = x.onerror = function() {
      if (x.status==200 && x.statusText=='OK')
         console.log(x.responseText);
      else
         console.log("Error");
    };
    x.send(JSON.stringify(data));
   
</script>
  
</body>
</html>