Return affected rows on table/record PUT

[Casey]

There is an option that can be set to "rows" according to swagger documentation to return the affected records and not just the count but every time I try it, only the count is returned.  Is there syntax that is not obvious?

[Vitalikssssss]

Hi @Casey,

There is a response parameter called "rows" which you need to specify in order to get a list of affected records.

Hope this helps.

Regards,

vitalikssssss

 

 

[Casey]

Thanks for your response, @Vitalikssssss however I'm still having some issues.  I had tried putting in the 'response' field the following things: rows, "rows", 'rows', row, "row", and 'row'.  All resulted with the following response: 

 

{

  "RecordsAffected": 1,

  "Result": []

}

 

The screenshot shows the exact recommendation you made, but all have the same results.  Any additional thoughts or is this just a bug in the api?

[Vitalikssssss]

@Casey, it looks like a bug to me too.

It is better to notify Support Team, so they could address it in one of the upcoming releases. 

regards,

vitalikssssss

 

 

[ChesCC]

Hi, was there ever a solution to this issue? I, too, am receiving an empty array as my "Result" even though I've used "Rows", "Row", etc.

I can see clearly that the update itself is working (& am receiving a 200 response), just having issue with the Result array.

[Nuke354]

@ChesCC

Have you also tried using Swagger UI to test? https://howto.caspio.com/web-services-api/rest-api/swagger-ui/

I have typed only rows on my end and it is working

[ChesCC]

Hi, yes, I was using Swagger.

I was able to fix my issue by removing the quotes around rows and using a single quote ' instead of a double quote " on my values in the q.where field

 

Thanks!

[RuisiHansamu]

Hi There, this is great. I have also tried to use these similar forum posts that helped me re-configure my API setup. For your references: 

 

https://howto.caspio.com/web-services-api/rest-api/special-considerations/