Send HTTP Request from local server to remote server

Question

I am using BaseX version 9.5, I am trying to send HTTP request from local to remote server to read database, but not getting the response.

let $server := 'http://10.102.xxx.xxx:8984/rest/'
let $sendreq    := (http:send-request(
              <http:request method='POST' username='admin' password='admin' send-authorization='true'
               href='{$server}' auth-method='Basic'>
               <http:body media-type="application/xml">
               {
                  collection('test')/*
               }</http:body>
                </http:request>
              ))[2]
 return $sendreq

Can anyone suggest how can I send query to remote server so that I could read and query to remote server database from my local server?

I understand you want to execute `collection('test')/*` on the remote. But it is currently executed on your local instance. — line-o, Feb 09 '23 at 12:18
What is going wrong here, how can I send this query to remote server? — Dharmendra Kumar Singh, Feb 09 '23 at 15:12

line-o · Answer 1 · 2023-02-13T21:38:42.853

0

To execute your query on a remote instance of basex

http:send-request(
  <http:request method='POST'
    href='{$remote-server-rest-endpoint}'
    username='{$remote-instance-user}'
    password='{$remote-instance-user-password}'
    send-authorization='true'
    auth-method='Basic'>
    <http:body media-type="application/xml">
      <query xmlns="http://basex.org/rest">
        <text><![CDATA[
          declare variable $a as xs:integer external;
          declare variable $b as xs:integer external;
          <mult>{ $a * $b }</mult>
        ]]></text>
        <variable name="a" value="21"/>
        <variable name="b" value="2"/>
      </query>
    </http:body>
  </http:request>
)

Adapted from the example found in the docs: https://docs.basex.org/wiki/REST#POST_Method

edited Feb 13 '23 at 21:38

answered Feb 09 '23 at 18:39

line-o

1,885
3
16
33

Thank you for looking this, i tried your given solution, it is throwing error. "[experr:HC0002] Conversion failed: "" (Line 10975): The markup in the document following the root element must be well-formed" – Dharmendra Kumar Singh Feb 10 '23 at 13:55
Without seeing the actual request element I cannot help you. – line-o Feb 13 '23 at 14:48
the same code I am running which you have given above, nothing changed. – Dharmendra Kumar Singh Feb 13 '23 at 15:13
let $remote-server-rest-endpoint := 'http://10.102.200.111:8984/rest/' let $sendreq := http:send-request( collection('test') )[2] return $sendreq – Dharmendra Kumar Singh Feb 13 '23 at 15:22
maybe start with a _very_ simple request `1+1` and see if that is returned. – line-o Feb 13 '23 at 21:32
I modified my answer to use an example from the docs – line-o Feb 13 '23 at 21:39
it is returning – Dharmendra Kumar Singh Feb 16 '23 at 05:55

Send HTTP Request from local server to remote server

1 Answers1