rest – node.js crud operations from a single view

maybe its a silly question but i’ve a fair amount of time looking trough google and i’ve reached and endpoint.

i’ve got my node app working performing crud operations with 2 tables from a sqlite db, the problem is that i have 1 view for each table (to make put and read requests), and i need at least 14 tables to store different data.

i wonder if there’s a way to read, create and etc from a single view, im thinking about create 14 views for reading and present data to the user but manage to retrieve and put data from 1 single view.

thanks a lot for helping im new at coding and i feel kinda lost.

sharepoint online – Get both columns in a list using REST

As per my understanding (by seeing the screenshots you attached), I think it is causing this issue because of using incorrect internal name of your Folder column.

Please check the internal name of your column using this method: Find the internal name of SharePoint column

Then you can use the REST endpoint like below:

<site-url>/_api/web/lists/getbytitle('Display Name of List')/items?$select=Title,InternalNameOfFolderColumn

Replace InternalNameOfFolderColumn with the internal name you got from above method.

Official documentation: Working with lists and list items with REST

Update from comments:

As per Dylan’s comment:

I think the problem is because SharePoint allowed the creation of a field with the internal name of “Folder”, which through the REST API is conflicting with the built-in Folder endpoint. I think the solution would be to create a new field with an internal name that is not exactly “Folder”, and then change the display name back to “Folder”, so that the internal name is not in conflict with the REST API.

spfx – I’m getting 403 access denied errors on REST calls in Monitor Mode; how can I turn off Monitor Mode?

My sessions are all being redirected with a loading/splash screen telling me my session is being monitored. My SPFx webpart loads fine but any action I take that requires a REST call, I get 403 Access denied console errors.

My url gets this .us3.cas.ms/ appended to it. So instead of site.sharepoint.com/sites... it’s site.sharepoint.com.us3.cas.ms/sites...

Relevant, but not very useful doc:

https://docs.microsoft.com/en-us/sharepoint/troubleshoot/administration/access-to-sharepoint-online-is-monitored

I’ve spent a while in the Microsoft Cloud App Security (security.microsoft.com/info) area of the admin console under Microsoft 365 Security and I can locate my name and see where policy is being invoked and my sign-ins are being redirected… But how do I turn this off completely? How do I stop this from happening to users? This completely blocks any REST calls and renders my SPFx solutions useless.

Any help is appreciated.

rest – What constitutes “identical” for the purposes of HTTP idempotence?

From RFC 7231 “Hypertext Transfer Protocol (HTTP/1.1): Semantics and Content” Section 4.2.2 “Idempotent Methods”:

A request method is considered “idempotent” if the intended effect on the server of multiple identical requests with that method is the same as the effect for a single such request. Of the request methods defined by this specification, PUT, DELETE, and safe request methods are idempotent.

RFC 2616 has similar text.

However, the term “identical” is defined in neither RFC.

It seems reasonable to assume that two requests that are literally identical, byte for byte, in all content (including headers and body) would be identical for this purpose.

It also seems clear that extrinsic properties of the request, such as the time it was sent (as long as it is not represented in the request), would be irrelevant to the “identical” disposition of the request. Otherwise idempotence would be a meaningless distinction.

However, are there any possible differences whatsoever between two requests, even for example differences in a single particular header, for any of the idempotent HTTP methods, that could nonetheless still constitute identical requests for the purpose of idempotence?

It seems to me that RFC 7231 or RFC 2616 alone do not answer this question directly, but I wonder if there is an RFC, specification, or otherwise generally authoritative source that does specify the answer to this question.

Or if a widely used dependent system (such as a highly utilized HTTP client or server) documents its expectations around “identical” for the purposes of idempotence, that would be fairly helpful as well.

design – How to call a list of REST APIs in huge volume to get optiomal performance?

I have written a Machine Learning based microservice in Python and using Flask for the REST endpoints. There is a need to pull data by calling around 4 REST APIs. But the call to the 2 APIs is going to be huge volume every day.

1st API – Max 1,000

2nd API – Max 2,50,000

3rd API – Max 1,80,000

4th API – Max 25,000

How should I call these APIs to get optimal performance?. I need to finish all the work in a couple of hours in worst case.

php – How to listen on WordPress REST API calls ( single post )

I’m building a mobile app and need to collect site visitors count through the mobile app using the only way available to me and that’s The REST API.

I found a plugin called WordPress Popular Posts collect visitors but only on the site.

So what I intend to do is listening on any single post API Request and update the page visitors manually using WordPress SQL.

My problem is I don’t know a way ( hook maybe ) to listen on the API requests and do what I explained above.

plugins – wp_get_post_terms is difference obj model than the one in rest api response

I’m building a mobile app and using the rest API on WordPress to do that, I am customizing the /wp/v2/posts response by using the following code:

add_filter('rest_prepare_post', 'custome_posts_response', 10, 3);

function custome_posts_response($data, $post, $context)
{
    $newspapers = wp_get_post_terms($post->ID, 'newspaper');
    $categories = wp_get_post_terms($post->ID, 'category');
    $tags = wp_get_post_terms($post->ID, 'post_tag');

    return (
        "id" => $post->ID,
        "title" => $post->post_title,
        "format" => $data->data('format'),
        "date" => $data->data('date'),
        "slug" => $data->data('slug'),
        "status" => $data->data('status'),
        "externalFeaturedImage" => $data->data('external_featured_image'),
        "sourceLink" => $data->data('source_link'),
        "content" => $post->post_content,
        "excerpt" => $post->post_excerpt,
        "author" => $data->data('author'),
        "newspaper" => $newspapers,
        "categories" => $categories,
        "tags" => $tags,
        "commentCount" => $post->comment_count,
        "commentStatus" => $post->comment_status
    );
}

My problem is the term OBJ in my above code print like that:

{
  term_id: 4,
  name: "Arabs Turbo",
  slug: "arabs-turbo",
  taxonomy: "newspaper",
  description: "",
  parent: 0,
  count: 181,
  filter: "raw"
}

I guess that because it a query for selecting all fields directly from the database and I don’t wanna that,

I need the response to be exactly as WP REST API Term model like the following:

{
   "id": 9,
   "count": 27,
   "description": "",
   "link": "http://localhost/carstime/newspapers/ahmed-el-wakil/",
   "name": "Ahmed El Wakil",
   "slug": "ahmed-el-wakil",
   "taxonomy": "newspaper",
   "meta": (),
   "_links": //...
}

So what method/function should I use to accomplish this instead of using wp_get_post_terms or mapping though the array using array_map for every taxonomy.

nginx – Allow only api routes (api/*) to access port 80 and 403, redirect the rest to 443

I currently have my nginx configured for redirecting port 80 to port 443.

server {
   listen (::):443 ssl
   listen 443 ssl;

   root /var/www/my_app/public;

   server_name example.com www.example.com;

   # rest of my main config
}

# Here is port 80 listen
server {
    if ($host = www.example.com) {
        return 301 https://$host$request_uri;
    } # managed by Certbot


    if ($host = example.com) {
        return 301 https://$host$request_uri;
    } # managed by Certbot


    listen 80 default_server;
    listen (::):80 default_server;
}

If I comment out the second server chunk and add listen 80 default_server; listen (::):80 default_server; to above chunk, it allows both http and https access.

What I want to achieve is, if url contains example.com/api/* don’t redirect http to https, but for the rest of the urls, redirect to https.

  • example.com/api/login = allow http
  • example.com/api/test = allow http
  • example.com/api-docs = redirect to https
  • example.com/anything = redirect to https

How can I achieve this with nginx? Do I need to have 2 server blocks and move shared logic in a separate file and consider them individually for each port?

7 – REST API and Multi value date field

I have a React native front end with D7 backend. I am populating a content type that has a multi-value Date field. I am successfully creating the content-type with all other fields except the Date field. The format I am sending via POST looks like :

"field__delivery_dates": {
        "und": [
           {
                "value": "2020-07-23"
               
            },
            {
                "value": "2020-08-05"
                
            },
            {
                "value": "2020-08-07"
                
            }
        ]
    }

The problem is when I sent the multiple date field values it’s getting submitting but the values are not reflected in drupal.

Anyone, please help me to find out a solution for sending a multi-field date field to drupal 7