Skip to main content

Dynamic XML element processing & Dynamic JSON generation from XML

xquery version "1.0" encoding "utf-8";

(:: OracleAnnotationVersion "1.0" ::)

declare namespace www="http://www.inc.teamshare.gems.com";
(:: import schema at "../Schemas/GemsTeamshareData.xsd" ::)
declare namespace pul="http://xmlns.oracle.com/pcbpel/adapter/db/top/Pull_GEMS_INCREMENTAL_DATA";
(:: import schema at "../Schemas/Pull_GEMS_INCREMENTAL_DATA_table.xsd" ::)

declare variable $inputVariable.GemsIncrementalDataCollection as element() (:: schema-element(pul:GemsIncrementalDataCollection) ::) external;
declare variable $TempListExtractData as element() (:: schema-element(www:TeamShareData) ::) external;

declare function local:funcJsonteamshare($inputVariable.GemsIncrementalDataCollection as element() (:: schema-element(pul:GemsIncrementalDataCollection) ::),
                                         $TempListExtractData as element() (:: schema-element(www:TeamShareData) ::))
                                         as element() (:: schema-element(www:JsonStringList) ::) {
    <www:JsonStringList>
    { 
    for $i in $TempListExtractData/www:TeamShareDataMain
    let $mainJsonOuter :=fn:concat("{&quot;__metadata&quot;: { &quot;type&quot;: &quot;",$inputVariable.GemsIncrementalDataCollection/pul:GemsIncrementalData/pul:tsListFullname/text(),"&quot;}")
    let $mainJsonOuterEnd :="}"
    let $mainJson :=""
    let $doubleQts :="'"
    return
        <www:JsonString>
            <www:id>{fn:data($i/www:DataSeq)}</www:id>
             <www:jsonString>{$mainJsonOuter}
            {
            for $inner in $i/www:TeamShareDataList where fn:not($inner/www:Value = '')   and    fn:not($inner/www:Key = '') 
            return fn:concat(", &quot;",$inner/www:Key,"&quot;:&quot;",fn:translate(fn:replace(fn:replace(fn:replace($inner/www:Value,'”','\\"'),'“','\\"'),'"','\\"'),'áàâäéèêëíìîïóòôöúùûü°','aaaaeeeeiiiioooouuuu.'),"&quot;")
            }{$mainJsonOuterEnd}</www:jsonString>
        </www:JsonString>
      }
    </www:JsonStringList>
};

local:funcJsonteamshare($inputVariable.GemsIncrementalDataCollection, $TempListExtractData)

Labels:

Comments

Post a Comment

Popular posts from this blog

Solution for BPM standard dashboard & activity guide not working in Oracle SOA 12.2.1.0 C

As earlier i publish a post about different issue of Oracle BPM, After some oracle support i got to fixed them. Issue Blog Here... Issue 3:BPM 12.2.1 process workspace activity guide not working. if you have a normal BPM Process, then this is the issue. In order to have data populated in "Activity Guide" firstly you should create a BPMN Guided Business Process. Below you can find the documentation about activity guide and how to create a Guided Business Process: https://docs.oracle.com/middleware/1221/bpm/bpm-develop/GUID-F765955D-90A5-48D4-8D2A-2F01FBB539E3.htm#BPMPD901 And here is specified: " A Guided Business Process is modeled as an activity guide that is based on a business process. The Activity Guide includes a set of Milestones. A milestone is a contained set of tasks that the end user has to complete. A milestone is complete when the user successfully runs a specific set of tasks in the milestone. " And in the below chapters you will find the ...
Post a Comment
Read more

Oracle SOA 12C rest adapter with Custom HTTP headers

Most existing web applications are connected through web services, which are commonly known as SOAP services. More and more users are relying on mobile devices for communication, and they’re looking for lighter ways to access enterprise information on the go. REST services are the answer for the mobile device platform, because they get rapid responses and fast access to data. Oracle SOA Suite 12 c  provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite 12 c  enables services to be created, managed, and orchestrated into composite applications and business processes. Some time we have need to send HTTP headers in REST service, In OSB we use header component and add what ever is needed but in oracle SOA 12C it's little bit different. Let see how we can do it. Create one SOA Application. Create one SOA Sample project inside SOA Application. Go to composite and drag drop REST ...
22 comments
Read more

Swagger API document from Any WADL & Schema in Oracle SOA

Hi everyone, Hope everyone is doing well these days, Recently i started a project work over how to generate swagger API document for your any REST API, In case if you don't know what is swagger please go and check " https://swagger.io/tools/swagger-editor/ ". It's a great and easy to use tool which will help to create user friendly, human readable form API documentation with extension for generating API client in different languages with capability of testing your API from same. What is swagger editor, Design, describe, and document your API on the first open source editor fully dedicated to OpenAPI-based APIs. The Swagger Editor is great for quickly getting started with the OpenAPI (formerly known as the Swagger Specification) specification, with support for Swagger 2.0 and OpenAPI 3.0.  What benefits you will get by using swagger, Runs Anywhere, The Editor works in any development environment, be it locally or in the web. Smart Feedback, Validate you...
8 comments
Read more