Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Definition Set that Describes an Empty Array object if no data returned

Recommended Posts

If someone has a good tutorial link, link or has answer that would be excellent. I need JSON output similar to this:



{ "status" : 1,

"status_message" : "NULL",

"result" : { "details": { "id" : 1234,

"title" : "A Title",

"description": "Descriptive text here"



"empty_array": []



I don't know xsd formatting at all, and xml only a little more. The CIS documentation is too simplified to describe this, and I'm unable to find a solution on the web.

Link to comment
Share on other sites

Try this ins a stored procedure.

OUT status INT,OUT status_message VARCHAR(255),OUT result CURSOR ( id INT, title VARCHAR(255), description TEXT),OUT empty_array CURSOR()

In the Web Service you can update the name insread of the output saying StoreProcesureStatus.

If the array is empty it will show empty_array = NULL in the json output.


I hope this helps!

Link to comment
Share on other sites

Close, but not the result I'm looking for. Here's what I got when I published the procedure:

{ "p_test_empty_array": { "status": 1, "status_message": "", "result": { "data_set_details": [ { "id": 1234, "name": "blarg", "description": "nonsense junk here", "class_name": "low" } ] }, "empty_array": "" }}

The empty_array isn't an array, it's an empty string. The developers who consume this REST service expect to see: "empty_array": [] -- open/close brackets. Or, they would also accept no "empty_array" attribute at all if no data is returned for that part.

A Cisco consultant here said it wasn't possible to get the former without and XSD (definition set), thus the reason for my post.

Link to comment
Share on other sites

  • 3 months later...

I figured out how to remove the empty array element by editing the XQuery for the transformation. It looks for an empty string in one of the array's elements - if null it ends there, otherwise it prints out all of the elements.

{ let $nodes := ( let $inputs := (if (empty($in_name)) then "NULL" else concat(concat("'",$in_name), "'") cast as xs:string) let $query := concat( "select status,status_message,id,title,description,characterization,first_name,last_name,nickname,occupation,user_id from /shared/snipped_to_protect_the innocent(", concat( string-join($inputs,","), ")")) let $data_set_details1 := composite:executeQuery($query)//result for $data_set_details in $data_set_details1 return element ns1:data_set_details { element ns1:status {$data_set_details/status/text()}, element ns1:status_message {$data_set_details/status_message/text()}, let $nodes := ( element ns1:result { let $nodes := ( element ns1:data_set_detail { element ns1:id {$data_set_details/id/text()}, element ns1:title {$data_set_details/title/text()}, element ns1:description {$data_set_details/description/text()}, element ns1:characterization {$data_set_details/characterization/text()}, for $data_set_details in $data_set_details1 return ----> if (empty($data_set_details/user_id/text())) then

Link to comment
Share on other sites

  • 3 weeks later...
  • 1 month later...

A little late,

you should be able to manually create an XSD or use something like xmlspy to define an XSD for you if you have an example XML output.

We've had to manually configure and XSD to ensure a consistent format.

Looks like you may already have an answer but hope it helps for future reference.

Link to comment
Share on other sites

  • 2 years later...
  • 4 weeks later...
  • Create New...