topic Re: Rest API Error in QlikView

Rest API Error

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am experiencing an error trying to connect to a web application after refreshing my Token. The Token refreshed successfully however when i try to insert the credentials into the insomnia application, i get an error. I tried running this off my companies network and it connected successfully. Please see the attached image.. I strongly believe this is a proxy issue but i don't have much knowledge about that.

Re: Rest API Error

sasiparupudi1 — Tue, 03 Apr 2018 19:56:38 GMT

Did you try pasting the url into the browser directly and see if it returns the json data or not?

Re: Rest API Error

taylor_jesse — Wed, 04 Apr 2018 14:00:06 GMT

Yes i did and it says bad request

Re: Rest API Error

sasiparupudi1 — Wed, 04 Apr 2018 14:04:27 GMT

Then it should be a token issue not qlikview?

Re: Rest API Error

taylor_jesse — Wed, 04 Apr 2018 14:07:01 GMT

What do you suggest? refresh the token?

Re: Rest API Error

sasiparupudi1 — Wed, 04 Apr 2018 14:21:21 GMT

Yes try it out

Re: Rest API Error

taylor_jesse — Wed, 04 Apr 2018 15:34:20 GMT

It worked however there was an error during the load. Please see the log file below

4/4/2018 10:51:39 AM: 4880 CUSTOM CONNECT*Provider*QvRestConnector.exe*XUserId*XPassword*

4/4/2018 10:51:41 AM: 4882 RestConnectorMasterTable:

4/4/2018 10:51:41 AM: 4883 SQL Select

4/4/2018 10:51:41 AM: 4884 "DateSubmitted",

4/4/2018 10:51:41 AM: 4885 "Team",

4/4/2018 10:51:41 AM: 4886 "Role",

4/4/2018 10:51:41 AM: 4887 "Facility",

4/4/2018 10:51:41 AM: 4888 "Question1A",

4/4/2018 10:51:41 AM: 4889 "Question1B",

4/4/2018 10:51:41 AM: 4890 "Question1C",

4/4/2018 10:51:41 AM: 4891 "Question1D",

4/4/2018 10:51:41 AM: 4892 "Question1E",

4/4/2018 10:51:41 AM: 4893 "Question2A",

4/4/2018 10:51:41 AM: 4894 "Question2B",

4/4/2018 10:51:41 AM: 4895 "Question2C",

4/4/2018 10:51:41 AM: 4896 "Question2D",

4/4/2018 10:51:41 AM: 4897 "Question2E",

4/4/2018 10:51:41 AM: 4898 "Q3_ProgramValue",

4/4/2018 10:51:41 AM: 4899 "Q4_ConcernsAddressed",

4/4/2018 10:51:41 AM: 4900 "Q4A_ManagementDetails",

4/4/2018 10:51:41 AM: 4901 "Q5_ProviderEducation",

4/4/2018 10:51:41 AM: 4902 "Q6_SatisfiedPartnership",

4/4/2018 10:51:41 AM: 4903 "Q6A_SatisfiedPartnership",

4/4/2018 10:51:41 AM: 4904 "Q7_JobSatisfaction",

4/4/2018 10:51:41 AM: 4905 "Q8_PatientCare",

4/4/2018 10:51:41 AM: 4906 "Q9_PatientSatisfaction",

4/4/2018 10:51:41 AM: 4907 "Q10_PatientIncrease",

4/4/2018 10:51:41 AM: 4908 "Q11_ChiefLeadership",

4/4/2018 10:51:41 AM: 4909 "Q12_ChartSatisfaction",

4/4/2018 10:51:41 AM: 4910 "Q13_TraineeConfidence",

4/4/2018 10:51:41 AM: 4911 "Q13A_TraineeConfidence",

4/4/2018 10:51:41 AM: 4912 "Comments1",

4/4/2018 10:51:41 AM: 4913 "Comments2",

4/4/2018 10:51:41 AM: 4914 "FollowUp",

4/4/2018 10:51:41 AM: 4915 "FollowUpEmail",

4/4/2018 10:51:41 AM: 4916 "TotalScore"

4/4/2018 10:51:41 AM: 4917 FROM JSON (wrap off) "Result"

4/4/2018 10:51:41 AM: 34 fields found: DateSubmitted, Team, Role, Facility, Question1A, Question1B, Question1C, Question1D, Question1E, Question2A, Question2B, Question2C, Question2D, Question2E, Q3_ProgramValue, Q4_ConcernsAddressed, Q4A_ManagementDetails, Q5_ProviderEducation, Q6_SatisfiedPartnership, Q6A_SatisfiedPartnership, Q7_JobSatisfaction, Q8_PatientCare, Q9_PatientSatisfaction, Q10_PatientIncrease, Q11_ChiefLeadership, Q12_ChartSatisfaction, Q13_TraineeConfidence, Q13A_TraineeConfidence, Comments1, Comments2, FollowUp, FollowUpEmail, TotalScore, __extra_,

4/4/2018 10:51:41 AM: QVX_UNEXPECTED_END_OF_DATA: The remote server returned an error: (404) Not Found.

Re: Rest API Error

sasiparupudi1 — Wed, 04 Apr 2018 17:11:34 GMT

how many records are you trying to pull using the url? may be try limiting the records to fetch at a time..You might have to check with the vendor on how to limit the number of records to be returned by the url

Re: Rest API Error

taylor_jesse — Wed, 04 Apr 2018 18:30:20 GMT

It worked. There were less fields in the script.

Thanks alot for your help

Re: Rest API Error

sasiparupudi1 — Wed, 04 Apr 2018 18:34:28 GMT

‌glad that you could make it work. Please close this thread by marking any helpful and a correct answer