210 questions
1
vote
1
answer
64
views
copy incremetal data from shopify using copy activity in azure synapse using version 2.0 linked service
currently we are fetching data from shopify using copy activity with version 1.0 shopify linked service. version 1.0 is going to get deprecated by the 3rd week of Oct 2025. version 1.0 supports query ...
- 224
0
votes
0
answers
26
views
azure synapse Processing time
When my Azure pipelines are triggered automatically, my processing time takes 1 hour... when I run it manually, it takes 30 minutes... why this difference could be happening... even if my pipelines do ...
- 1
0
votes
0
answers
97
views
Call MS Fabric REST API from Synapse notebook
I am trying to call MS Fabric Semantic model refresh API from Synapse notebook.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group#example-of-refreshing-a-dataset
...
- 555
0
votes
0
answers
43
views
How connect and process on-prem HDFS data from Azure Synapse
I want to write data from an Azure Synapse notebook to an on-prem HDFS file system. While Azure Synapse provides Copy Activity for reading data, there doesn't seem to be a direct way to write data ...
0
votes
1
answer
97
views
Can I run stored procedures from Azure Data Factory which are hosted on an on-premise SQL Database (via a Citrix Datacentre)
We have some production stored procedures which need executing in the middle of the day using our on-prem servers, is it possible for these to be trigger via an Azure Data Factory Pipeline on our ...
0
votes
2
answers
158
views
WSO2 ESB: Using iterate and aggregate mediators without sending the split messages to an endpoint
In my scenario, there are no backend calls. I need to update some details of records in a database by looping through each record and sending a single aggregated email notification to the user with ...
0
votes
1
answer
117
views
Unable to import custom package in Azure Synapse notebook after successful installation
Problem Description
I am trying to import a custom Python package named check_excel_errors in an Azure Synapse notebook. The package was installed successfully using pip, but when I try to import it, ...
- 175
0
votes
1
answer
219
views
Get Max date value from append variable array - azure synapse pipeline
In my Synapse pipeline, I am looping through a set of filenames. Inside the loop, I use a "Get Metadata" activity to retrieve the last modified date of each file and append these dates to an ...
- 27
0
votes
1
answer
196
views
REST API call from synapse notebook to any other services outside azure not working ( power bi , Google)
REST API call from synapse notebook to any other services outside azure not working ( power bi , Google)
ex:
test_url = "https://www.google.com"
response = requests.get(test_url)
print("...
0
votes
1
answer
50
views
Create column of current balance in PySpark
I have the below dataframe created in PySpark code:
+---------------+-------------+---------------+------+
|TransactionDate|AccountNumber|TransactionType|Amount|
+---------------+-------------+--------...
- 5
2
votes
1
answer
181
views
How to get username of API caller in wso2 apim in Basic Authorization?
As you know we have 3 types of Authorization in WSO2 API management API Call: Basic, ApiKey, OAuth
I need to extract username of API caller. I used this way as you can see in this link: https://...
- 301
1
vote
1
answer
141
views
JsonNull UnsupportedOperationException on null value using WSO2 JsonTransform Mediator
I'm using a JsonTransform Mediator in my sequence to make sure a phone number field in my database query is returned as a string instead of as a number.
<jsontransform description="JSON ...
- 23
0
votes
2
answers
287
views
How to access API Version in WSo2 MI backend
I am trying to access the API version set in the API Manager frontend, defined via an openAPI v3.0.3 spec, in the Micro Integrator backend - I can see this is defined in the API Overview page. However ...
- 36
1
vote
1
answer
230
views
WSO2 IntegrationStudio 8.2.0 Endpoint requiring SSL
I've an endpoint which can be reached only through SSL validation. E.g. to reach it by Google Chrome, I've installed xxxx.p12 certificate. On other implementations, such as python, I can reach the ...
- 51
-1
votes
2
answers
152
views
Joining two tables with different sizes takes hours to execute
Here is the scenario:
we are using Azure Synapse analytics with 100 DTU, we have several tables.
All tables are round robin distributed and clustered columnstore because data is loaded once in a day ...
1
vote
1
answer
709
views
WSO2 API Manager(wso2am-4.0.0) - Where are the synapse configurations located in the latest version?
I'm currently using wso2am-4.0.0 and I have been using wso2am-2.1.0 previously.
In the previous version, a synapse configuration xml per each API could be located in the below folder path.
<...
- 395
1
vote
1
answer
210
views
XSL:FO to PDF Mediator fails in "no object DCH for MIME type application/pdf"
I’ve written a simple XSL:FO to PDF mediator. The transform of the XSL:FO document seems a success, but returning a PDF does not seem to work.
In the axis2.xml file I’ve added the rules for ...
-1
votes
1
answer
66
views
WSO2EI 7.1.1 File Processing not working on centos server
I am trying this tutorial from this given link https://ei.docs.wso2.com/en/latest/micro-integrator/use-cases/tutorials/file-processing/
Here is the file proxy definition
<?xml version="1.0&...
- 518
0
votes
2
answers
249
views
HashiCorpVaultLookupXPathFunctionProvider cannot be found by synapse-core_2.1.7.wso2v182
I am currently using wso2 integration studio 8.0.0 to develop a service and integration project works solid in in my local both in integration studio runtime and local docker engine. However, when I ...
- 63
0
votes
0
answers
160
views
in WSO2 I can't store image in a property
in WSO2 I try to make a call to given URLs to get png images in a pretty basic way. Then when I try to store/enrich I get the same error every time:
> [2021-07-02 16:38:38,357] ERROR {RelayUtils} - ...
0
votes
1
answer
445
views
WSO2 API Manager 3.2.0 - Cannot remove "Server" header
According to official docs defining a custom out sequence and adding <property name="CustomTransportHeader" scope="transport" action="remove"/> would remove any ...
- 188
1
vote
1
answer
209
views
No setPayloadJSON() in Apache Synapse
I have been trying out Apache Synapse and been trying to use the JavaScript mediator to set the JSON payload. But the ScriptMessageContext class doesn't contain any method for reading a JSON payload ...
- 845
0
votes
1
answer
363
views
REST Proxy Server with Apache Synapse
Iam new to the ESB's and Apache Synapse. I have a simple REST API that takes a GET method and returns a simple json response. I tried to create a proxy with Apache Synapse.
The configuration is given ...
- 845
0
votes
1
answer
259
views
How to use Apache Synapse callout mediator to send a given transport header
I'm trying to leverage the callout mediator to call a REST endpoint.
But I need to send the contents of a received HTTP header.
I tried:
<callout passHeaders="false">
<...
- 2,852
0
votes
1
answer
587
views
How to transform SOAP to JSON array in wso2 ESB using script mediator?
I'm trying to transform the soap request coming from our clients to the REST service we have using wso2 script mediator.
Input (SOAP):
<tran:Request xmlns:tran="http://schemas.demo.com/tran....
- 1,105
1
vote
0
answers
43
views
Basic queries related to client server communication
I have some very basic queries on synapse and client communication. Thanks in advance.
I thought normal Android phones do not have secure storage with them (although some high end phones do have ...
- 131
0
votes
1
answer
765
views
WSO2 AM endpoint timeout doesn't work correctly
In my case, I did a test with calling an API. Following is my selected logs:
2020-10-05 15:38:43,585 - sThroughMessageProcessor-12 - DEBUG g.apache.synapse.core.axis2.Axis2FlexibleMEPClient: [] ...
- 352
0
votes
1
answer
539
views
To read LocalEntry values in WSO2 EI
I am trying to read local Entry values based on dynamic user input(if Feed is user Input, then values inside Feed (host,user,password etc) should be fetched. but values not getting fetched for me. can ...
- 997
1
vote
1
answer
157
views
Is Apache Synapse being planned to migrate to Java 11?
Is Apache Synapse updated as per Java 11 ?
The latest release of Apache Synapse, dates to December 2017, which is from 3.0.1 version.
While loading the classes from the jar, encountering ...
- 5,921
1
vote
2
answers
1k
views
Use variables for URI in WSDL mediators WSO2
I am re-factorizing a wso2 project and I wondered how/whether I could do the following. This project is designed to send data to a SOAP Api. In every environment, this API exposes a .wsdl file and the ...
- 3,221
0
votes
0
answers
450
views
SynapseXPath Evaluation of the XPath expression functx:substring-before-match
I fail to use functx:substring-before-match in one of my mediation sequences
<property expression="functx:substring-before-match($trp:FILE_URI, 'CMDE[a-zA-Z0-9_]*\.zip')" name="baseFolder"/>
[...
- 3,221
1
vote
0
answers
73
views
wso2 quickfixj fix.4.2 message from broker
Good morning everyone,
I have problem when waiting for fix message from my broker to my wso2.
i have setup my proxy for got fix message from them like
<?xml version="1.0" encoding="UTF-8"?>
&...
- 137
4
votes
1
answer
1k
views
WSO2 EI, How to get payload as String from Custom Class mediator
I have created my own MediatorClass. Which has this major method:
public boolean mediate(MessageContext context) {
// TODO Implement your mediation logic here
return true;
}
Now there is a ...
- 7,973
1
vote
0
answers
191
views
Enabling OAUTH on WSO2 API Manager's built-in product endpoints such as /services/echo, /services/Version and /services/WorkflowCallbackService
The standard configuration of WSO2 API Manager 2.6.0 exposes a number of product services without enforcing authentication and authorisation controls through the usual OAuth token mechanism employed ...
0
votes
1
answer
292
views
Is it possible to process HTML response from Call mediator?
No matter what I tried – enrich body to STRING property, log response – I always get an exception, which is probably related to html not being proper xml. I do not need traverse html at all, I just ...
2
votes
1
answer
483
views
Can I obtain the full URL path of an endpoint inside WSO2 handler/mediator?
I am using WSO2 AM 2.6, with two domains pointing to the GW host:
domain1.com
domain2.com
Is there a way to figure out, inside a mediator or a custom handler, if the API was invoked using domain1.com ...
- 421
2
votes
3
answers
2k
views
Is there a way to set a default value for a property mediator if the property does not exist in the request body?
I am building a simple API in WSO2 EI/ESB. I am saving each of the request parameters to properties like so:
<property expression="json-eval($.client_id)" name="client_id" scope="default" type="...
- 48
0
votes
0
answers
242
views
Is it possible to use transaction mediator in Enterprise Integrator with DSS payloadFactory+Call?
I need to manually control transaction flow across several DB calls, that needs to be executed sequentially
My use case:
Create transaction
Insert record to a table
Update record in a different table ...
0
votes
1
answer
302
views
XPath as a string variable / property
I retrieve XPath from a database (via DSS) and I need to apply it to the body. Is this somehow possible?
To give an example, let's say I have this xml request
<custom>
<id>24</id&...
1
vote
1
answer
449
views
WSO2 EI Deploy Updated Artifact
I have a question regarding WSO2 EI Deployment. Here is the scenario, I had create 4 API for my project.
For the first time deployment. I generated 1 CApp file consist of 4 API and other artifact ...
- 155
1
vote
1
answer
359
views
ESB Proxy XML Request inside CDATA tag in SOAP request
I am new to Apache Synapse. I need to do content-based routing and proxying of a SOAP service. However, the actual request is an XML document inside a CDATA tag in the body of the SOAP request. ...
- 13
0
votes
3
answers
539
views
WSO2 EI send an email with attachment, CC and BCC recipient
I am following this tutorial to enable the MailTransportSender and MailTransportListener. I manage to send an email to the DevNullSMTP, SMTP Server.
My question now is. How to add CC and BCC ...
- 155
1
vote
1
answer
810
views
Wso2 Fault Sequence Error Handling Header
I am currently developing an API that will send a request to the Endpoint and will response back to the client.
On my fault sequence, I will log the error code and error message by using the ...
- 155
1
vote
1
answer
2k
views
WSO2 ESB how to read XML attribute response from the Endpoint
I have create one API witch call and Endpoint and return some response. Base on the response the Endpoint return, I want to retrieve the status value and proceed to the next step.
This is my api.xml ...
- 155
0
votes
1
answer
407
views
WSO2 Custom Mediator Set value for the Envelope
Deal All,
I'd create one custom mediator in my WSO2 ESB project at the OutSequence.
I would like to change the result in SOAP Envelope being send from the back end to the consumer. But with a little ...
- 155
1
vote
0
answers
190
views
GlowRoot for WSO2 EI
Is there a way to integrate web services that hosted in WSO2 EI in Glowroot?
Currently, WSO2 Carbon UI Request(9443) is log in Glowroot Web Transaction.
But when I request in Web Services(8280) there'...
- 3,698
1
vote
1
answer
855
views
Use a Custom Header WSO2
I have two apps, one that authenticate some user and generate a jwt if the user is valid, and save this jwt on the header with the name custom, as you can see:
var jwt = require('jsonwebtoken')
...
0
votes
0
answers
187
views
API Gateway is not calling global mediaton extension - WSO2 AM 2.2.0
I am following given documentation to create a global synapse mediator, but it seems that my mediator is not used. When I upload the same mediator XML to the API on publisher, works properly.
My XML ...
- 13
1
vote
1
answer
1k
views
WSO2 inline prototyping: How to get variables different that "path type"?
I'm using the WSO2 2.1.0 inline prototyping feature, as shown in
Create a Prototyped API with an Inline Script
This sample use the Synapse ScriptMessageContext to get the variables.
But I'm only ...
- 2,208
2
votes
0
answers
353
views
synapse and https 500 error
There was a problem with the passage of authorization on the site https://www.google.com for receiving data.
I use synapse HTTPSend. Connection I do as follows:
procedure TForm1.Button2Click(Sender: ...
