How to make viewaction. used my external api data instead of the Model data.

Hi good day! Everyone I want to make viewaction used the external api data and not the dabase table. Since i am using api data and not database query. My problem is it keeps throwing an error “SQLSTATE[42522]. Invalid column name TaskId select * from table where taskid =2341” it seems it is keep on using the model ? Thanks
5 Replies
biebthesecond
biebthesecond3w ago
You could try using the Sushi package? And connect that to your api
xdtyreswgsia
xdtyreswgsiaOP3w ago
Thank you for your reply. I tried to used sushi. But my problem with it is that. I can’t show the pagination. Since we can’t pass the total_count to sushi getRows(). The API i used. Only returns 10 items per request with total_count = 100.
do you have idea on how to do it with sushi?
Thanks
biebthesecond
biebthesecond3w ago
Now I just woke up, but maybe if the pagination gets stored in a ur query param you could use the URL facade to get that param and pass it to your api
xdtyreswgsia
xdtyreswgsiaOP3w ago
Thank you for that! i will try and see if it works. 🫡
biebthesecond
biebthesecond3w ago
Let me know if it works, I have to solve something like this soon as well

Did you find this page helpful?