api-search | Search public API | REST library

From this question Python (Google Sheets API) - Searching for a certain string and returning the whole row I use code, and returning the whole row by the value of a single cell.

How can I returning the values of two cells and return certain cells from this row?

For example, in the attached table you need to return the values of the "values" and "actions" columns from the rows containing the cells "14.05.2021" (the "date" column) and "Bob" (the "employee"column).

Attached table

I scraped tweets using tweepy using code based on first answer of this question, which is as following

I'm trying to make sortable/pageable/filterable repository with multiple filter methods. This is how my relevant code looks right now:

I am very new to react (started a day ago). I used the create-react-app command line to create an app. The following is the order I did

• create-react-app my-app
• npm start

Now app is running.

• npm install youtube-api-search
• npm start

Now i am getting this error

my-app@0.1.0 start /Users/shanmugharajk/Code/udemy/my-app react-scripts start

sh: react-scripts: command not found npm ERR! file sh npm ERR! code ELIFECYCLE npm ERR! errno ENOENT npm ERR! syscall spawn npm ERR! my-app@0.1.0 start: react-scripts start npm ERR! spawn ENOENT npm ERR! npm ERR! Failed at the my-app@0.1.0 start script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

This happens every single time with any package I try to install.

One thins I noted is when i run

• npm install youtube-api-search or any pckage it always removes some package. The message I am getting while installing any package is

npm WARN registry Using stale data from https://registry.npmjs.org/ because the host is inaccessible -- are you offline? npm WARN registry Unexpected warning for https://registry.npmjs.org/: Miscellaneous Warning ENOTFOUND: request to https://registry.npmjs.org/redux failed, reason: getaddrinfo ENOTFOUND registry.npmjs.org registry.npmjs.org:443 npm WARN registry Using stale package data from https://registry.npmjs.org/ due to a request error during revalidation. npm WARN gentlyRm not removing /Users/shanmugharajk/Code/udemy/my-app/node_modules/html-minifier/node_modules/.bin/uglifyjs as it wasn't installed by /Users/shanmugharajk/Code/udemy/my-app/node_modules/html-minifier/node_modules/uglify-js npm WARN gentlyRm not removing /Users/shanmugharajk/Code/udemy/my-app/node_modules/espree/node_modules/.bin/acorn as it wasn't installed by /Users/shanmugharajk/Code/udemy/my-app/node_modules/espree/node_modules/acorn npm WARN gentlyRm not removing /Users/shanmugharajk/Code/udemy/my-app/node_modules/autoprefixer/node_modules/.bin/browserslist as it wasn't installed by /Users/shanmugharajk/Code/udemy/my-app/node_modules/autoprefixer/node_modules/browserslist npm notice created a lockfile as package-lock.json. You should commit this file. + redux@3.7.1 added 3 packages, removed 1142 packages and updated 3 packages in 27.043s

I couldn't figure out the reason. Please help me.

I have a requirement to create a REST api. Api allows user to provide dynamic search criteria in URL. For example, let say I have NOTES table with column as Note_ID, NOTE_TEXT, STATUS, PERSON_ID. This table is used to keep notes of every person.

Now I want my REST api to be as https://server:host/MyApi/Notes?search=NoteText=='My Java adventure'. API should provide all notes having NOTE_TEXT as 'My Java adventure'. Similarly user can provide status also in url and also he can use operators as LIKE. I was able to do it via rsql parser as mentioned in https://www.baeldung.com/rest-api-search-language-rsql-fiql

Now I have additional requirement that based on user security person_id filter should be applied on query automatically.

I found that we can't have findBy method which can take Specification, Pageable and extra personId. For example I can't have a repository function as findByPersonId(Specification spec, Pageable page, Long personId);

I thought of using SpEL to use it, but then I found that if we use @Query annotation on findBy method, Specifications are ignored.

Seems like there is no way I can have Specification and @Query both. I need to add more clauses using specification only. In reality my where clause is very complex which I have to append and getting it with Specification seems to be difficult. Its something like Select * from NOTES where exists (select 'x' from ABC a where n.person_id = a.person_id)

Is there a way I can write @Query and also have Specification working on top of it?

Ideally I have achieve a query like

I am using ElasticSearch 7.3, to query some documents,
I want to return only specific fields of each document in the query response,
I found that _source can be used to achieve this,
Which I was able to do from Kibana using this query -

I'm trying to develop a search API with Specification and RSQL. Followed this tutorial - https://www.baeldung.com/rest-api-search-language-rsql-fiql

I have a User entity which have a OneToOne relation with UserProfile.

I have following code which is rendering the React app.

i have three files

video_list.js