Query all news under a certain category restful specification URL how to write

there is a news system in the project, which is divided into international news, domestic news and industry news. It is stored in the database table bigclass, and international news is divided into financial news, sports news and entertainment news. Domestic news and industry news are also divided into many small categories, which are stored in the database table smallclass, all the news content is stored in the news table, and the news table has a smallclass_id associated with the table smallclass. If you need to query all the news in a small category, you can write:

http://www.example.com/api/smallclass/5/news

but what should I do if I want to query all the news under a certain category? There is no direct relationship between the news table and the bigclass table.

Rest

May.22,2021

this has nothing to do with restful. If news and bigclass are not related, there must be a relationship between smallclass and bigclass, so that news and bigclass can be associated through smallclass.

if you want to write according to the restful specification, url should look something like this:

http://www.example.com/api/bigclass/:bigclass_id/smallclass/:smallclass_id/news

or pass bigclass to the server as query, for example:

http://www.example.com/api/smallclass/:smallclass_id/news?bigclass_id=123

I don't quite understand what you mean. On the surface, it looks very simple. Look up the bigclass data, then write:

http://www.example.com/api/bigclass

but it feels like there is something wrong with your restful design. According to the restful design specification, you are accessing the resource news, not the category bigclass or smallclass.
so your news query URL should look like this:

http://www.example.com/api/news?bigclass=XXX&smallclass=YYY

in the future, if you want to return all news categories, the URL of the category you get should look like this:

http://www.example.com/api/smallclass

there are two kinds:

GET / api/v1/news?bigclass= {big_class_id}
GET / api/v1/bigclasses/ {big_class_id} / news

as for the database part, just associate it.

Resources RESTful API Design Gu ide-Ruan Yifeng's web log $6, Filter information (Filtering)

Previous: How to keep the redux-devtools plug-in interface at the forefront, or how to set it up in the console

Next: The npm run build index.html page is blank and an error is reported

How to use the token front end in the RESTful interface?
the backend gives a RESTful interface document, and the request header needs a token to return success. Did I write this token when I was requested by the front-end ajax? What s the point if is not generated dynamically? this is how my Mini Program...

Restful interface javascript

Feb.27,2021
The problem of Django REST framework as a video upload interface
there is no problem with uploading small files on (iOS, Android) on mobile devices, but there are some larger files (more than 50m). After the upload progress is completed, it will take a long time for the server to return response information, and some...

Django django-rest-framework

Feb.28,2021
RESTful's. Net webapi routing and URL's doubts
the first time you use "ASP.NET MVC4 WebAPI " to develop a project, you only need to use WebAPI because the front end invokes the rendering directly by HTML+Ajax. < H2 > doubt 1 < H2 > what elegant posture do the great gods use to avoid the growth ...

Restful webapi

Feb.28,2021
Should id be placed in the path of API or in request?
I see an example when he deletes the id is put in the url, as follows router.delete( :id ,function(req,res){}) but you do put it in req.body when you update it, as follows router.update( ,function(req,res){ req.body._id }) Why is this?...

Rest-api api express

Feb.28,2021
How to construct a total api for multiple api, of django rest framework to call more than one api at a time
"task1": "http: localhost:8000 api task1 ", "task2": "http: localhost:8000 api task2 ", "task3": "http: localhost:8000 api task3 ", requestapi? "big_job": "http: localhost:800...

Django-rest-framework django

Feb.28,2021
The content of the Http uploaded file obtained by Python's Django-rest-framework framework is incorrect after the file is saved.
after getting the uploaded file, write the uploaded file stream to the server file. The file contains more http stream related information --X-INSOMNIA-BOUNDARY Content-Disposition: form-data; name="file"; filename="a.txt" Content...

Django-rest-framework python

Mar.01,2021
Failed to restart openresty. I would like to ask the correct order.
the path to install is usr local openresty nginx Today, the nginx.conf file has been modified. It needs to be saved and restarted execute: [root@newoneacreland ~]-sharp usr local openresty nginx-s reload -bash: usr local openresty nginx: Is ...

Openresty

Mar.02,2021
How to realize batch deletion by using RESTFUL API in json-server
when using vue to manage the system in the background, there will be batch deletion operations, but after finding a lot of information, it still can not be solved. I hope to get your help. axios({ method: delete , url: that.baseURL, params: ...

Axios restful

Mar.02,2021
Nginx wants to push logs to some http interface. Can nginx itself do this?
can nginx itself do that? It is better to use openresty ...

Lua openresty nginx

Mar.02,2021
Openresty ngx.re.find cannot uniquely match
< H2 > describe my problem < H2 > system: debian 8.0x64 server: Openresty 1.13.6.1 default installation novice, the question is relatively simple, I beg your pardon problem description: I need to implement a unique match on request_uri (request p...

Debian regexp openresty lua nginx

Mar.04,2021
How to use java to implement a webservice interface that can access linux local file data?
1. How to use java to implement a webservice interface that can access linux local file data? 2. Files are larger text files (about 2G) 3. Is there a better way, such as storing text files in an appropriate database (such as whether mongdb is appropria...

Java webservice restful linux

Mar.04,2021
Questions about QQ interconnected documents of Oauth2
there are two modes of OAuth protocol in Tencent QQ Internet platform. The specific process is understood, but the differences in usage scenarios are not clear: the first is client-side mode : using OAuth2 s Implicit_Grant mode the second is serv...

Restful rest rest-api oauth2.0 oauth

Mar.05,2021
Nodejs restful api authentication authorization
question 1: how does nodejs implement restful api authentication? has tried jwt, but cannot expire actively after token is signed. That is to say, for example, if a user logs in and issues a two-hour token, the token is valid within two hours. ...

Token oauth2.0 express restful node.js

Mar.06,2021
How to control the permissions of the RESTFUL interface provided by the back end in the separation of the front and back end?
encountered a problem today I have a system, which is role-based permission control. the front end naturally controls the view that should be displayed according to the role. but in order to prevent others from directly using httpclient access, then...

The-java spring front-and-back-end-separates-the permission restful

Mar.07,2021
What is the difference between how browsers implement POST and PUT requests?
when learning REST, I learned that POST requests are non-idempotent, while PUT requests are idempotent, so POST is suitable for adding and PUT is suitable for modification. there is a question here, is the idempotency here just a difference in definitio...

Put post restful rest

Mar.07,2021
On the Security of token and session generated by jwt
now the project I am working on is separated from the front and rear ends, mainly the development of the api interface. The login logic is like this. first, the user logs in with the account password. If it is correct, the user will automatically genera...

Jwt session token restful java

Mar.13,2021
Django rest framework API, web request prompt 403 error
you can get data normally by using postman request. request using web page with error message: { "detail ": "CSRF Failed: CSRF cookie not set. "} how to solve this? ...

Django django-rest-framework

Mar.16,2021
Get post, are these stipulated by http or restful?
get post are these stipulated by http or restful? I am the front end, and I always thought that get post is stipulated by the http protocol. but recently, when I saw what restful is, I saw that get is used to obtain, and post is used to create new on...

Protocol https restful rest http

Mar.16,2021
The front-end interview asked Restful, what he wanted to know.
according to the interface I currently use Restful, the front end only needs to know how to use get , post , put , delete to make the corresponding request. and the corresponding semantics of various http code. You will be able to satisfy the com...

Restful javascript

Mar.16,2021
The use of presto's projectNode
recently read the presto source code, do not understand the role of projectNode? only knows that it is used for projection, which can be explained simply. ...

Hive presto

Mar.20,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3efef-2bcaf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3efef-2bcaf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?