Is there a way to pull data into clipboard from a browser result?
On my Current project, we are interacting with external system to get JSON format data. The result data will need to be display in a drop-down list on the user screen.
We cannot use web services to interact with the external system because the external system requires JavaScript and cookies to be enabled on the request; the external system response needs to be
rendering on a browser.
In my POC, I added a link in one of the section and pass in the URL using “Open URL in Window” action on the click of the link. Upon doing this, I was able to display the response to the browser. Now the challenges are:
- How do I run the URL in the background because the client does not want the user to click on a link?
- How can I get the result from the browser into the clipboard which will then feed in into the drop-down list for the user?
Any help or Idea will be greatly appreciated
***Updated by moderator: Marissa to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
Wow, that's a complicated problem. If the response is structured in such a way that you get access the data via JavaScript, you can map it to properties (hidden or visible based on business need) and from there to the clipboard when you submit the form. I don't think Open URL in Window is the ideal solution since it takes you outside of the PRPC context and I assume your ability to directly manipulate it via JS. I believe you might be able to get open URL in space to allow it to be in a context where you can work with it, although it's not something I've ever done, so I could be way off base. I'm not sure what cross site scripting problems you are going to run into, but that could turn this exercise into a deal breaker. openUrlInSpace is something that could be called directly in JavaScript (although you are going outside the guardrails), which should allow you to set this up in the background. Presumably you could code it to then refresh a section and pass data on to the clipboard for the dropdown (via another refresh section perhaps).
I'm sure much of that is an oversimplification, but hopefully it helps. Good luck!
BNY Mellon
US
What's the necessity of putting it on the clipboard?
You could do this independent of Pega, using any number of Javascript-based choose-from-list components, e.g., http://jqueryui.com/autocomplete/#remote-jsonp
Jon is correct, you would want to read about Connect-REST which will return response in JSON format, which can be plugged into Pega UI directly to render Table widget, drop down etc...
https://community.pega.com/sites/default/files/help_v71/procomhelpmain.htm
https://community.pega.com/sites/default/files/help_v71/procomhelpmain.htm
Pegasystems Inc.
US
The issue here is we can not use Connect-REST for this;we need to render the result in browser and I do not think we can do that using Connect-REST. However, I am currently looking into Jon suggestion and see if that can be implemented with spacial-component UI to display the result in section.
Pegasystems Inc.
US
Hi Ebenezer,
We keep mentioning Connect-REST here and I just wanted to explain a little on why. When you try Connect-REST it's giving you a an error message that makes it seem like the the call to the service needs to be done client side, with a browser. We don't have an OTB way of calling a service from the client side but we have an very robust level of connectors that run on the server that are used to get data from services so they can be placed into the clipboard so business logic can process the data and/or stream processing can be used to display the data. This is why we keep mentioning Connect-REST because it's a perfect fit, we can parse the JSON response to the clipboard and display the results to your end users in any format you want with minimal effort.
You are getting the following error message from the service when using Connect-REST:
"JavaScript and cookies are required to access this site"
Is there some sort of NTLM authentication required to access this service? A browser will handle the negotiation for that so that is probably why it works fine when run from a browser level. Regardless, I have no doubt that you could configure the PRPC environment to be able to communicate with this service. This does require discussing accessing this service from a process, PRPC being the process, with the service provider. This is not a hard conversation but it has to occur and configuration planned and implemented.
Hi Ebenezer,
We keep mentioning Connect-REST here and I just wanted to explain a little on why. When you try Connect-REST it's giving you a an error message that makes it seem like the the call to the service needs to be done client side, with a browser. We don't have an OTB way of calling a service from the client side but we have an very robust level of connectors that run on the server that are used to get data from services so they can be placed into the clipboard so business logic can process the data and/or stream processing can be used to display the data. This is why we keep mentioning Connect-REST because it's a perfect fit, we can parse the JSON response to the clipboard and display the results to your end users in any format you want with minimal effort.
You are getting the following error message from the service when using Connect-REST:
"JavaScript and cookies are required to access this site"
Is there some sort of NTLM authentication required to access this service? A browser will handle the negotiation for that so that is probably why it works fine when run from a browser level. Regardless, I have no doubt that you could configure the PRPC environment to be able to communicate with this service. This does require discussing accessing this service from a process, PRPC being the process, with the service provider. This is not a hard conversation but it has to occur and configuration planned and implemented.
We don't have a OTB way to make this service call from the client side so it populates the clipboard and then is displayed in a HTML control associated with a property reference. Anything we could provided you here would not be guardrail compliment. This could be done with AJAX call to get the data from the service, then another to send the data PRPC on the correct thread page, parse the data then trigger a reload of the section you want to display. That is really ugly and complicated. You could also try implementing direct jquery and JSON and some of the Javascript files are in PRPC 7 but not directly used for what you are trying to accomplish.
The internal team I am on owns your support request and we have been talking about this issue daily. We will get together with you today or tomorrow to discuss next steps.
Pegasystems Inc.
US
Hi Chris,
yes there Is some sort of NTLM authentication required to access this service which we have implemented in the Connect-Rest. I did some screen sharing yesterday with Gopi Ganapathy which is assign person on the ticket ( SR-129302) that was raised on this issue. That would be great if you want to together later today. Just FYI - The client group that owns the external system is not willing to make any change on their end.
Pegasystems Inc.
US
Hello Ebenezer,
Thanks for your usage of the Pega Product Support Community. If I understand correctly, you have a Support Request (SR) for this issue. Since you have engaged a Support Engineer via a SR, this discussion will be marked as closed.
We look forward to seeing your future participation in the Community!