Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Retrieving Data Error

Hi, I did a query time ago that was working perfectly until today and it started retrieving data like this:     We didn't modify the file, the data source or the steps, and I tried different...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    Looks like that 503 error from Sharepoint is the issue.  WHatever it's returngin to the query is being read as binary data - hence the odd characters you are seeing.

     

    Check Sharepoint and reconfirm that you can accesss the files you want.

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi Anonymous 

 

So the CSV file you are importing is actually a text CSV?  Not binary?

 

Can you confirm Parameter5 contains the correct path and filename for the CSV? Try hardcoding the path/filename to test.

 

Can you post the CSV in question for me to check.

 

Regards

 

Phil

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Philip, thanks for taking the time.  

The CSV I'm importing are actually Excel files; xlsx, and all the Parameters that I had, they were automatically labelled as Binary, and worked always fine. 

 

 

The Parameter5 contains the correct Path and filename. The files are placed into a Sharepoint and we retrieve the data from there. 

 

I don't know if the query might get corrupted by any reason, but I also got this error message and I think it has to do with that, Error 503, which actually is a Server-side problem.