LookUp Connection Problem

Question

Hello,

I am continuing to get this error when I try to debug this pipeline. ![111054-screen-shot-2021-07-01-at-123900-pm.png][1]

This is the dataset that the error is referring to. ![110998-screen-shot-2021-07-01-at-15152-pm.png][2]

Answer 1

For those who are seeing similar issues, I have resolved the problem. Keep in mind that csv filed formats DO NOT save the new data format that you input.
My specific incident required a yyyy-mm-dd date format as my input. Date formats are tricky for csv files so alter your data pipeline parameters then
you should be in good shape.

Answer 2

Hi @John Kim ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

By looking at the error message it seems like the error is from the http server end. I would also request you to double check if it is an intermittent issue. If so then you can try setting up retry option which would avoid this issue.

In case if the issue is consistent, then you will have check the input values for the HTTP call for the failed pipeline run and do same testing using same input data in Postman to verify if the issue is related to any of the input data for the HTTP call. And also please make sure the returned data is in expected format. You can also verify the failed HTTP response with the success response by doing a comparision.

Hope this info helps. Do let us know how it goes.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.