How to use invoke http to perform GET request in nifi?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







1















I need to perform a get request from nifi to couchbase. The curl command is:



curl http://HOST:PORT/query/service -d "statement=select item.Date from bucket unnest bucket as item" -u USER:PASSWORD


I tried using InvokeHttp and ExecuteStreamCommand but it keeps returning errors(status code 400). The full error message is:




{ "requestID": "bff62c0b-36fd-401d-bca0-0959e0944323", "errors":
[{"code":1050,"msg":"No statement or prepared value"}], "status":
"fatal", "metrics": {"elapsedTime": "113.31µs","executionTime":
"74.321µs","resultCount": 0,"resultSize": 0,"errorCount": 1




It's important to say that I prefer that the http request will be triggered by an incoming flowfile. I tried using the processors in various of ways but non of them worked.
When I run the command from the nifi server it works fine.



Thanks for the help










share|improve this question





























    1















    I need to perform a get request from nifi to couchbase. The curl command is:



    curl http://HOST:PORT/query/service -d "statement=select item.Date from bucket unnest bucket as item" -u USER:PASSWORD


    I tried using InvokeHttp and ExecuteStreamCommand but it keeps returning errors(status code 400). The full error message is:




    { "requestID": "bff62c0b-36fd-401d-bca0-0959e0944323", "errors":
    [{"code":1050,"msg":"No statement or prepared value"}], "status":
    "fatal", "metrics": {"elapsedTime": "113.31µs","executionTime":
    "74.321µs","resultCount": 0,"resultSize": 0,"errorCount": 1




    It's important to say that I prefer that the http request will be triggered by an incoming flowfile. I tried using the processors in various of ways but non of them worked.
    When I run the command from the nifi server it works fine.



    Thanks for the help










    share|improve this question

























      1












      1








      1








      I need to perform a get request from nifi to couchbase. The curl command is:



      curl http://HOST:PORT/query/service -d "statement=select item.Date from bucket unnest bucket as item" -u USER:PASSWORD


      I tried using InvokeHttp and ExecuteStreamCommand but it keeps returning errors(status code 400). The full error message is:




      { "requestID": "bff62c0b-36fd-401d-bca0-0959e0944323", "errors":
      [{"code":1050,"msg":"No statement or prepared value"}], "status":
      "fatal", "metrics": {"elapsedTime": "113.31µs","executionTime":
      "74.321µs","resultCount": 0,"resultSize": 0,"errorCount": 1




      It's important to say that I prefer that the http request will be triggered by an incoming flowfile. I tried using the processors in various of ways but non of them worked.
      When I run the command from the nifi server it works fine.



      Thanks for the help










      share|improve this question














      I need to perform a get request from nifi to couchbase. The curl command is:



      curl http://HOST:PORT/query/service -d "statement=select item.Date from bucket unnest bucket as item" -u USER:PASSWORD


      I tried using InvokeHttp and ExecuteStreamCommand but it keeps returning errors(status code 400). The full error message is:




      { "requestID": "bff62c0b-36fd-401d-bca0-0959e0944323", "errors":
      [{"code":1050,"msg":"No statement or prepared value"}], "status":
      "fatal", "metrics": {"elapsedTime": "113.31µs","executionTime":
      "74.321µs","resultCount": 0,"resultSize": 0,"errorCount": 1




      It's important to say that I prefer that the http request will be triggered by an incoming flowfile. I tried using the processors in various of ways but non of them worked.
      When I run the command from the nifi server it works fine.



      Thanks for the help







      http curl get couchbase apache-nifi






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Jan 3 at 14:59









      Gal ItzhakGal Itzhak

      5919




      5919
























          2 Answers
          2






          active

          oldest

          votes


















          3














          the -d parameter of the curl utility forces HTTP POST command



          and application/x-www-form-urlencoded mime-type.



          so, in the nifi InvokeHTTP select the following parameters



          HTTP Method                   = POST
          Remote URL = <your url here>
          Basic Authentication Username = <username>
          Basic Authentication Password = <password>
          Content-Type = application/x-www-form-urlencoded


          and the body of the flow file should be



          statement=select item.Date from bucket unnest bucket as item





          share|improve this answer



















          • 2





            Thank you so much, problem was in the content type!

            – Gal Itzhak
            Jan 3 at 15:24



















          1














          I don't know nifi, but based on the error message, the "statement=" part of the request isn't being included, or you are not sending the request as a POST command.






          share|improve this answer



















          • 1





            yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

            – Gal Itzhak
            Jan 3 at 15:21












          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54024789%2fhow-to-use-invoke-http-to-perform-get-request-in-nifi%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          3














          the -d parameter of the curl utility forces HTTP POST command



          and application/x-www-form-urlencoded mime-type.



          so, in the nifi InvokeHTTP select the following parameters



          HTTP Method                   = POST
          Remote URL = <your url here>
          Basic Authentication Username = <username>
          Basic Authentication Password = <password>
          Content-Type = application/x-www-form-urlencoded


          and the body of the flow file should be



          statement=select item.Date from bucket unnest bucket as item





          share|improve this answer



















          • 2





            Thank you so much, problem was in the content type!

            – Gal Itzhak
            Jan 3 at 15:24
















          3














          the -d parameter of the curl utility forces HTTP POST command



          and application/x-www-form-urlencoded mime-type.



          so, in the nifi InvokeHTTP select the following parameters



          HTTP Method                   = POST
          Remote URL = <your url here>
          Basic Authentication Username = <username>
          Basic Authentication Password = <password>
          Content-Type = application/x-www-form-urlencoded


          and the body of the flow file should be



          statement=select item.Date from bucket unnest bucket as item





          share|improve this answer



















          • 2





            Thank you so much, problem was in the content type!

            – Gal Itzhak
            Jan 3 at 15:24














          3












          3








          3







          the -d parameter of the curl utility forces HTTP POST command



          and application/x-www-form-urlencoded mime-type.



          so, in the nifi InvokeHTTP select the following parameters



          HTTP Method                   = POST
          Remote URL = <your url here>
          Basic Authentication Username = <username>
          Basic Authentication Password = <password>
          Content-Type = application/x-www-form-urlencoded


          and the body of the flow file should be



          statement=select item.Date from bucket unnest bucket as item





          share|improve this answer













          the -d parameter of the curl utility forces HTTP POST command



          and application/x-www-form-urlencoded mime-type.



          so, in the nifi InvokeHTTP select the following parameters



          HTTP Method                   = POST
          Remote URL = <your url here>
          Basic Authentication Username = <username>
          Basic Authentication Password = <password>
          Content-Type = application/x-www-form-urlencoded


          and the body of the flow file should be



          statement=select item.Date from bucket unnest bucket as item






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 3 at 15:20









          daggettdaggett

          9,53321631




          9,53321631








          • 2





            Thank you so much, problem was in the content type!

            – Gal Itzhak
            Jan 3 at 15:24














          • 2





            Thank you so much, problem was in the content type!

            – Gal Itzhak
            Jan 3 at 15:24








          2




          2





          Thank you so much, problem was in the content type!

          – Gal Itzhak
          Jan 3 at 15:24





          Thank you so much, problem was in the content type!

          – Gal Itzhak
          Jan 3 at 15:24













          1














          I don't know nifi, but based on the error message, the "statement=" part of the request isn't being included, or you are not sending the request as a POST command.






          share|improve this answer



















          • 1





            yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

            – Gal Itzhak
            Jan 3 at 15:21
















          1














          I don't know nifi, but based on the error message, the "statement=" part of the request isn't being included, or you are not sending the request as a POST command.






          share|improve this answer



















          • 1





            yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

            – Gal Itzhak
            Jan 3 at 15:21














          1












          1








          1







          I don't know nifi, but based on the error message, the "statement=" part of the request isn't being included, or you are not sending the request as a POST command.






          share|improve this answer













          I don't know nifi, but based on the error message, the "statement=" part of the request isn't being included, or you are not sending the request as a POST command.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 3 at 15:05









          Johan LarsonJohan Larson

          1,5601814




          1,5601814








          • 1





            yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

            – Gal Itzhak
            Jan 3 at 15:21














          • 1





            yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

            – Gal Itzhak
            Jan 3 at 15:21








          1




          1





          yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

          – Gal Itzhak
          Jan 3 at 15:21





          yes, the problem is that I don't how to configure the processor to include the data. Looking at the processor documentation, it says that the content of the incoming flowfile should be sent as the data but it doesn't work

          – Gal Itzhak
          Jan 3 at 15:21


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54024789%2fhow-to-use-invoke-http-to-perform-get-request-in-nifi%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

          SQL update select statement

          'app-layout' is not a known element: how to share Component with different Modules