Rest API Error

[taylor_jesse]

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.

[sasiparupudi1]

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

[taylor_jesse]

Yes i did and it says bad request

[sasiparupudi1]

Then it should be a token issue not qlikview?

[taylor_jesse]

What do you suggest? refresh the token?

[sasiparupudi1]

Yes try it out

[taylor_jesse]

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.

[sasiparupudi1 · Accepted solution]

Hi

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

[taylor_jesse]

It worked. There were less fields in the script.

Thanks alot for your help

[sasiparupudi1]

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