Update SQL Row failed

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have an Asana flow to insert a row when Asana task is created. This works fine.

I have created another flow to update that row when the task is completed, it is returning an error however, the error is also not very descriptive. Any ideas?

INPUTS

Table name
TaskTable
Row id
222620863461201
TaskID
222620863461201
TaskNotes
DueDate
2016-12-07
DueDT
CompletedDT
2016-12-07T18:20:44.637Z
ModifiedDT
2016-12-07T18:20:52.902Z
ProjectName
BOSTIK

OUTPUTS

Headers
{ "Pragma": "no-cache", "x-ms-request-id": "b7744288-13d4-40bc-a547-d24f33db0b06", "Cache-Control": "no-cache", "Date": "Wed, 07 Dec 2016 18:21:38 GMT", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "88", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }
Body
{ "status": 404, "message": "Failed to update item '222620863461201'.", "source": "127.0.0.1" }

All responses (2)

Answers (1)

v-micsh-msft on at

Like (0)

Report

Re: Update SQL Row failed

Hi TimWilsonPrem,

What is your current situation?

If you need any further help, or have any further questions, please feel free to post back.

Regards
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Update SQL Row failed

It's too early in the morning. I re-read and saw the 404.

All good. Thanks