Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bkozisek5r
Contributor III
Contributor III

Qlikview RestConnector - Cannot parse data in selected response type

This is my first time trying to use the RestConnector so this hopefully is a simple step i'm missing.  I am trying to connect to USDA AMS data mart and the connection tests good.  However when i try and select data, choosing XML as this is what the USDA documentation states as the return format I am receiving the following error: "Cannot parse data in the selected response type. Check the "Response Type" parameter value.  XML was not Found"

The USDA documentation i am working with is http://marketnews.usda.gov/USDA-LMR-WebService-Client-User-Guide-v1_prod.pdf.

Thank you in advance for any assistance you may have.

5 Replies
petter
Partner - Champion III
Partner - Champion III

I get data back without problem trying one of the example URLs in the USDA documentation. No error message just the expected data coming into QlikView.

I used this URL https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100?filter=%7b%22filters%22:%5b%7b%22fiel...

and several others and I got no error messages. Could you describe closer what you actually filled out where?

bkozisek5r
Contributor III
Contributor III
Author

I was trying to use just this portion in the URL https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100

And then the report date in the parameters section.

Thank you for your response.  I am also getting it to work using the full URL with the report date selection included.

bkozisek5r
Contributor III
Contributor III
Author

Sorry, One more question.  Could you help me with the proper way to make the URL dynamic so that i can have it auto refresh and pickup the new information each day?

Thanks

Brandi

petter
Partner - Champion III
Partner - Champion III

You can use variables in the load script and do a $-sign expansion within the connection string to get the date dynamic (or any other part of the connection string actually).

vDate = Date(Now(1),'MM/DD/YYYY');

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100?filter%2%%7b%%22filters%%22:%%5b%%7b%...$(vDate)%%22%%5d%%7d%%5d%%7d;timeout=30;method=GET;sendExpect100Continue=True;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;authSchema=anonymous;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;XUserId=cPKQXOC;XPassword=PTVSGXA;";

The Connection String use a special kind of URL encoding where:

charactersubstituted
=%2
{%%7b
"%%22
[%%5b
<space>%%20
]%%5d
}%%7d
petter
Partner - Champion III
Partner - Champion III

If this answered your question please mark the answer as correct