Forum Discussion

tech321's avatar
tech321
Contributor
5 years ago

soapui parameter equivalent to curl parameter

Hi, here is my curl command that generates data in excel sheet.  curl --header "Content-Type: application/octet-stream" http://ipAddress:port/export --output myExcel.xlsx I am trying to do the same...
  • tech321's avatar
    tech321
    5 years ago

    Hi guys, finally I found it. See the attached screenshot. A 'Save to file' button, then I call the file anyName.xlsx and  I get the expected excel file. Very good and thanks for your help. 

tech321's avatar
tech321
Contributor

Thank you . please se those attachments. 

1- the encoded string that I need to decode

2- the groovy code I use

3- the generated excel file by the groovy code

4- the curl command with --verbose

richie's avatar
richie
Community Hero
5 years ago
tech321,

Ok...so what is the logged response for response2 in your groovy?
I suspect there might be problems because readyapi! isn't recognising your response as .xml.....the screenshot of the response you provided typically is generated when it hasnt been parsed by xml or json cos it isnt recognised as either of those. If the xml parser isnt recognising the response payload then xpath wont work.
Can you click RAW and XML tabs....can you provide screenshots please?

Also...im trying to remember...where did you get the requirement for xls?

Is it just a convenient form of output to your requests?

Can you do me a favour. Grab the base64 encode from your response and plug it into https://www.base64decode.org and run the decode? We need to know what the encoded data is actually. I assumed from your previous posts that the encode was of xls data, but that doesn't make sense to me.

Ta

Rich
  • tech321's avatar
    tech321
    Contributor
    5 years ago

    I have attached screen shots as answers for your questions.

    The logget response for response2 is just to strip the decoded string from tags as you can see in the scerrenshot.

    I am not sure about your question regarding the requirement for xls. I want the output at an excel file, exactly the same way I, when I use curl. 

    • richie's avatar
      richie
      Community Hero
      5 years ago
      tech321,

      The decode didnt work....you wouldnt expect a load of escaped nonsense in the decoded content if it had worked.

      I was asking about thr spreadsheet cos i wondered if the encoded value included the .xlsx container or not.

      You keep saying "i want it like i get it with curl cos its easy and straightforward" but what you need to appreciate is that readyapi!/soapui will do almost whatever you need for api testing as a consequence of its rich functionality, it enables the user to exercise so many different types of api, this means setup can be a lot more complicated in readyapi!/soapui.
      [Disclaimer: no i don't work for Smartbear!]

      On the decode webpage it says something like "for documents and binaries use the option further down the page" your stuff is of binary type (according to your Content-Type header).
      As an aside. I think this is probably why your decode is failing!

      Once youve run the decode successfully can you please take screenshot of the decoded binary?

      I know this is tedious, but each time you give the forum more info, it answers a certain facet of your issue.

      Nice one

      Rich
      • tech321's avatar
        tech321
        Contributor
        5 years ago

        I have attached a screenshot to be sure of what you are asking about. 

        I have tried to save the decode file as xslx and then uploaded it and then decode it, and the result is a bin file which is still useless. 

        My question here is, what is the expected format of the file name is?