DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sandhya.budhi



Group memberships:
Premium Members

Joined: 15 Nov 2017
Posts: 4

Points: 107

Post Posted: Thu Dec 14, 2017 4:42 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I wanted to do a REST call using a JSON file. The REST call should be made using the below JSON payload

Code:
"Queue":[
 {
      "YYYYYYYY",
       "AA",
       "07",
        "2017-11-14",
   false,
   "2017-11-14",
        15.2,
   "YYYYYYY",
   false,
   "SPACER",
   false,
        "07",
   "Japan export",
   "C",
        0.000,
   "NONE",
   "YYYYYY",
   false,
   false
},
{
       "XXXXXX",
       "AA",
       "07",
        "2017-11-14",
   false,
   "2017-11-14",
        15.2,
   "XXXXXXX",
   false,
   "SPACER",
   false,
        "07",
   "Japan export",
   "C",
        0.000,
   "NONE",
   "XXXXXX",
   false,
   false
  }
]


I am creating the schema for JSON composer stage and it is giving me an error message the schema is invalid. I am looking some help in creating the JSON schema for having a JSON object inside an JSON array.

Code:
  "type": "array",
  "items":[
    "type": "object",
      {
        "name": "string"
      },
      {
        "address": "string"
      },
      {
        "area": "string"
      },
      {
        "dob": "string"
      },
      {
        "Status": "boolean"
      },
      {
        "rec": "string"
      },
      {
        "counter": "number"
      },
      {
        "desig": "string"
      },
      {
        "worktool": "boolean"
      },
      {
        "desc": "string"
      },
      {
        "reman": "boolean"
      },
      {
        "area2": "string"
      },
      {
        "req_reason": "string"
      },
      {
        "suspend": "string"
      },
      {
        "seqno": "number"
      },
      {
        "crb": "string"
      },
      {
        "dcc": "string"
      },
      {
        "base": "boolean"
      },
      {
        "deleted": "boolean"
      }
]

_________________
Thanks,
Sandhya
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42280
Location: Denver, CO
Points: 217097

Post Posted: Thu Dec 14, 2017 7:13 pm Reply with quote    Back to top    

<added code tags>

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours