mdx – SSRS : How to give parameter values in URL Http requests?

I created a dataset in an SSRS report and this dataset uses a parameter. Here is the request:

select { (Measures).(ID Distinct Count)} on COLUMNS,
non empty filter({ (DIM ANESTH).(PBM ANE NOM).(PBM ANE NOM) }, 
not InStr( (DIM ANESTH).(PBM ANE NOM).CURRENTMEMBER.MEMBER_VALUE, 'Unknown') = 1) on ROWS
from BDD_PAT_ANESTH where ( StrToSet(@param_req, Constrained))

param_req is a parameter name I gave, and SSRS created a corresponding report parameter and joined both. Here are some screenshots:

the parameter
in the report datas
how the parameter is filled
some default values

All it works, but I want to call the report server via http requests (in C#), and provide with some parameter values. Usually, SSRS http URLs finish by the parameters : …&param1=value1&param2=value2 and so on. But I don’t see how I can provide with the value “(DIM ANESTH).(ID).&(3)” for example.

An other way could be to define a custom parameter whose values are integers, and to define a second parameter whose origin is the first one and whose values are some members like “(DIM ANESTH).(ID).&(3)”.

Do you know how I can achieve either method (I think the first one could be easier).

thank you.

PS: I found this about parameters but it seems to be only partially relevant.

java – HTTP Status 404 – Não Encontrado – Servlet JAVAEE

Bom dia, sou iniciante em Java e estou enfrentando problemas com minha servlet, procurei, pesquisei e não consegui compreender o problema exato. Deixarei aqui os arquivos e ficarei extremamente grato com a vossa ajuda.

Minha servlet

    package servlets;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class MainServlet extends HttpServlet{
    private String salarioMinimo;
    private double sal = Double.parseDouble(salarioMinimo);
    
    
    
    public void init(ServletConfig config) throws ServletException{
        super.init(config);
        this.salarioMinimo = (config.getInitParameter("salarioMinimo"));
        System.out.println("Servlet Iniciada"); 
    }
    
    public void destroy() {
        System.out.println("Servlet Finalizada");   
    }
    
    public void service ( HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException   {
        PrintWriter pw = response.getWriter();
        String Operador = "Operarador tem o salario de " + this.salarioMinimo;
        pw.write(Operador);
        String Lider = "Lider tem o salario de " + this.sal*1.5;
        pw.write(Lider);
        String Encarregado = "Lider tem o salario de " + this.sal*2;
        pw.write(Encarregado);
        String Supervisor = "Lider tem o salario de " + this.sal*2.5;
        pw.write(Supervisor);
        String Gerente = "Lider tem o salario de " + this.sal*3;
        pw.write(Gerente);
        String Diretor = "Lider tem o salario de " + this.sal*5;
        pw.write(Diretor);
        
            
        
    }

}

Meu arquivo xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0">
  <display-name>ex01</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    <servlet-name>Principal</servlet-name>
    <servlet-class>servlets.MainServlet</servlet-class>
    <init-param>
        <param-name>SalarioMinimo</param-name>
        <param-value>1045</param-value>
    </init-param>
  </servlet>
  <servlet-mapping>
    <servlet-name>Principal</servlet-name>
    <url-pattern>/principal</url-pattern>
  </servlet-mapping>
  
</web-app>

Print do projeto no exlipse

tls – Man in the middle using HTTPs downgrade to HTTP

In general browsers attempt to establish a HTTPs-Connection if possible. How would you force a browser to fallback to HTTP when somebody enters asdf.xyz in the search bar of his/her browser without specifying a protocol?

Therefore: sslstrip is probably not helpful as there are no links to “fake”. Furthermore, it is assumed that the site does not use HSTS.

Assuming one can perform MITM – how would the routing with iptables be performed/which commands would you need to make the browser believe that HTTPs is not available and to fallback to HTTP?

Warning: Unnecessary HSTS header over HTTP

we would like to add the HSTS header to our page https://www.wipfelglueck.de
Our page is running on a shared server, so we don’t have access to the httpd.conf. We tried to enable this header via the .htaccess file like this:

<ifmodule mod_headers.c>
  DefaultLanguage de
  Header set X-XSS-Protection "1; mode=block"
  Header set X-Frame-Options "sameorigin"
  Header set X-Content-Type-Options "nosniff"
  
  Header set X-Permitted-Cross-Domain-Policies "none"
  
  Header always set Strict-Transport-Security "max-age=31536000; includeSubDomains; preload"
  
  Header set Referrer-Policy: no-referrer
  
  <FilesMatch ".(js|css|xml|gz)$"> 
    Header append Vary Accept-Encoding 
  </FilesMatch> 
   
  <filesMatch ".(ico|jpg|jpeg|png|gif|webp)$">
   Header set Cache-Control "max-age=2592000, public"
  </filesMatch>
  <filesMatch ".(css|js|json|html)$">
   Header set Cache-Control "max-age=604800, public"
  </filesMatch>
</IfModule>

When we check the page we receive the warning in subject with this text:
“The HTTP page at http://wipfelglueck.de sends an HSTS header. This has no effect over HTTP, and should be removed.”

I tried some ways to solve this, but was not successful so far. In the web I can’t find a solution, so I would be happy if you could give me a hint on this!

Thank you very much!!

sharepoint online – Error updating person group field using “Send Http Action” in flow

I am trying to update person/group column using power automate . I am getting below error

An unexpected ‘PrimitiveValue’ node was found when reading from the JSON reader. A ‘StartObject’ node was expected.
clientRequestId: bbf41a14-51dd-4cd0-8ac8-67313f4cf6a5
serviceRequestId: 539c869f-a0d9-b000-66c0-1ac6d790fbd
9

I am able to successfully retrieve the user ID but the update fails.

{
‘__metadata’: { ‘type’: ‘SP.Data.Partner_x0020_Training_x0020_RegistrationListItem’ },
‘RegisteredByStringId’: ‘(@{variables(‘UserID’)})’
}

When i query using link below, the results for my
“RegisteredBy” column are as below

https://siteurl/Business%20Development/_api/web/lists/getbytitle(‘Partner%20Training%20Registration%20Hub’)/items(96)

Business%20Development/_api/web/lists/getbytitle(‘Partner%20Training%20Registration%20Hub’)/items(96)

<d:RegisteredById m:null=”true” /><d:RegisteredByStringId m:null=”true” />

TRied using both these column names but no luck.

Article reference

Updating a multi-people field in SharePoint with Microsoft Flow

HTTP issue

Hi,

I have vps with cpanel, use PHP-FPM. The website no sure with HTTPS. But when website serve with HTTP, the PHP-FPM will not respond. … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1826279&goto=newpost

jsonp – Simple Java HTTP Server application that responds in PJSON

I want to create a very simple HTTP server Java with PJSON responds.
Here is the code:

public static void main(String() args) throws Exception {
     HttpServer server = HttpServer.create(new InetSocketAddress(8500), 0);
      HttpContext context = server.createContext("/test");
      context.setHandler(Sample::handleRequest);
      server.start();
     System.out.println(" Server started on port 8500");
    }    
 
 private static void handleRequest(HttpExchange exchange) throws IOException {
      JSONObject json = new JSONObject("{"weight":"23400"}");
      exchange.getResponseHeaders().add("Access-Control-Allow-Origin", "*");
      exchange.getResponseHeaders().add("Access-Control-Allow-Headers","origin, content-type, accept, authorization");
      exchange.getResponseHeaders().add("Access-Control-Allow-Credentials", "true");
      exchange.getResponseHeaders().add("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS, HEAD");
      exchange.getResponseHeaders().set("contentType", "application/json; charset=UTF-8");
      exchange.sendResponseHeaders(200, json.toString().getBytes().length);
      OutputStream os = exchange.getResponseBody();
      os.write(json.toString().getBytes());
      os.close();
  }

and client:

$(document).ready(function () {
        $.ajax({
            url: 'http://localhost:8500/test/',
            type: "GET",
            dataType: "jsonp",
            data: { no: 120 },
            contentType: 'application/json',
            success: function (data) {
                $('#txtWeight').val(data);
            },
            error: function (err) {
                console.log( err);
            }
        });
    });

The problem that I have is related to the HTTP Handler. The Chrome returns:
Cross-Origin Read Blocking (CORB) blocked cross-origin response http://localhost:8500/test/?callback=jQuery34109210173679568667_1603222391566&no=120&_=1603222391567 with MIME type text/plain

Could you please have a look and tell me if something is wrong?

Why doesn’t a simple Http request to display a remote web page violate the Same Origin Policy?

On a w3schools page, I found that HTTP requests work like this:

  • A client (a browser) sends an HTTP request to the web
  • A web server receives the request, and runs an application to process it
  • The server returns an HTTP response (output) to the browser
  • The client (the browser) receives the response.

On the same page I found that an XMLHttpRequest works like this:

  • A browser creates an XMLHttpRequest object and sends it to the server
  • The server processes the request, creates a response and sends data back to the browser
  • The browser processes the returned data using JavaScript and updates the page content.

The above two processes appear pretty much the same to me. However, the latter one violates the Same Origin Policy (SOP) if the server runs on a remote domain. This question on stackoverflow about the url in the open() method says that

As we can only send requests to our own web server, I assume that we don’t have to rewrite the website’s name in the URL.

Applying the same logic to the first case (Http requests) would mean that I couldn’t open a web page if it is not on my own computer. Luckily, this is not the case.

So, why doesn’t an Http request to display a remote web page violate the SOP? What is the key point/difference here?

I assume it’s about the fact that the second process (XMLHttpRequest) is initiated from a script, while the first one is triggered by the user. However, isn’t the Http request sent from a script when I click a hyperlink on a web page? And how can a web server distinguish between requests coming from a script and coming from a user?

SharePoint Designer 2013 Workflow HTTP Web Service on POST: Error – The given key was not present in the dictionary

Thank you for reading this. This is a bit long, but I’m trying to be as detailed as possible. Any help would be greatly appreciated. If more info is needed, please let me know. As info, I am not a (JavaScript) developer. I’ve been tasked to do as many things as possible OOTB.

Environment: SharePoint Online and SharePoint Designer 2013 (for workflows).

Scenario: Have a Team Site and a Subsite to it. When an item is added to a Custom List in the Subsite, the workflow is to find the matching task in the Task List on the Parent Site and mark the Task Status as “Completed”. (A variable is created in the workflow to match the item added to the list with the task.)

Success: Using the HTTP Web Service action to GET Task items via the Workflow. Evidenced by logging the response in a custom list using Create Item in List workflow action.

Issue: Using POST to add or update a Task to the task list. Continue to get the error {“error”:{“code”:”-1, System.Collections.Generic.KeyNotFoundException”,”message”:{“lang”:”en-US”,”value”:”The given key was not present in the dictionary.”}}}

Pre-conditions: Because we were going between site and subsite, we followed the articles to create elevated workflow permissions for use of the App Step. Did this on both the site and subsite. https://msdn.microsoft.com/en-us/library/office/jj822159.aspx, http://www.fabiangwilliams.com/2014/06/19/gotcha-on-sharepoint-designer-workflows-in-app-step/

Because this error seems to sometimes be illusive, decided to create the workflow on lists within the same Team Site to remove any possibility of authorization issue. Therefore the example shown below is not using APP Steps.

Trouble-shooting: Used Fiddler with Chrome to walk through and did not receive any errors. https://cann0nf0dder.wordpress.com/2016/09/12/getting-fiddler-to-work-with-sharepoint-online/. Viewed many, many articles also.

Workflow:

  1. Hard-coded a Variable = TempMatchString to match with a value in the Task List to bring back specific Task(s). Ignore first two lines of the workflow – will be used once the issue is resolved.

enter image description here

  1. Get Matching Task(s)

    • Build GET_RequestHeader Dictionary.
      Accept = application/json;odata=verbose as String and
      Content-Type = application/json;odata=verbose as String

    • Perform the GET HTTP Web Service request with URL: https://mycompany.sharepoint.com/HumanResourcesTS/_api/web/lists/getByTitle('ProgressReportTasks')/Items?$filter=(Title eq (%Variable:TempMatchString%)

    • Create Item in the SPListGETContent list to view the response.

    • Store the array returned in Variable “ListDataSet”. Note: I am using Get valueinstead of d/results. If I do the GET Call from the subsite I get the JSON returned with d/results as seen in most all articles online, but value when used on the parent site. I am not sure why this differs.

    • Count to number of items returned.
      enter image description here
  2. Get FormDigestValue

Read several articles stating need to set the X-RequestDigest to the FormDigestValue to POST.

Thank you!!