Not all fields from OpenEdge Service object shown when assig

Posted by Ruben Dröge on 18-Mar-2016 03:34

I imported the following JSDO-catalog with multiple OE Service objects.

{
    "version": "1.2",
    "lastModified": "Fri Mar 18 07:41:45 UTC 2016",
    "services": [{
        "name": "RollbaseService",
        "address": "\/rest\/RollbaseService",
        "useRequest": true,
        "resources": [
            {
                "name": "Klant",
                "path": "\/Klant",
                "autoSave": false,
                "schema": {
                    "type": "object",
                    "additionalProperties": false,
                    "properties": {"dsKlant": {
                        "type": "object",
                        "additionalProperties": false,
                        "properties": {"ttKlant": {
                            "type": "array",
                            "primaryKey": ["KL-NR"],
                            "items": {
                                "additionalProperties": false,
                                "properties": {
                                    "_id": {"type": "string"},
                                    "_errorString": {"type": "string"},
                                    "id": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "id"
                                    },
                                    "seq": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "seq"
                                    },
                                    "KL_NAAM": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "NAAM"
                                    },
                                    "KL_NR": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "NR"
                                    },
                                    "KL_ST": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "ST"
                                    },
                                    "KL_TL": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "TL"
                                    },
                                    "KL_TN": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "TN"
                                    },
                                    "POSTCODE": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Postcode"
                                    },
                                    "JUVO_CO": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "JUVO"
                                    },
                                    "JUSI_CO": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "JUSI"
                                    },
                                    "KL_FANA": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "FANA"
                                    },
                                    "KFL_VONA": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "VONA"
                                    },
                                    "roep": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Roepnaam"
                                    },
                                    "rijksreg": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "00000000000",
                                        "title": "Rijksregister"
                                    },
                                    "gebplaats": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Geboorteplaats"
                                    },
                                    "geslacht": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 1,
                                        "title": "Geslacht"
                                    },
                                    "land": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "BE",
                                        "title": "Land"
                                    },
                                    "natio": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "BE",
                                        "title": "Nationaliteit"
                                    },
                                    "GSM": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "GSM"
                                    },
                                    "burgstand": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Burgerlijke stand"
                                    },
                                    "lknr": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Lk.Nr"
                                    },
                                    "huisnr": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Huisnr."
                                    },
                                    "bus": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Bus"
                                    },
                                    "straat": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Straat"
                                    },
                                    "email": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "E-mail"
                                    }
                                }
                            }
                        }}
                    }}
                },
                "operations": [
                    {
                        "path": "",
                        "useBeforeImage": true,
                        "type": "update",
                        "verb": "put",
                        "params": [{
                            "name": "dsKlant",
                            "type": "REQUEST_BODY"
                        }]
                    },
                    {
                        "path": "?filter={filter}",
                        "useBeforeImage": true,
                        "type": "read",
                        "verb": "get",
                        "params": []
                    },
                    {
                        "name": "count",
                        "path": "\/count?filter={filter}",
                        "useBeforeImage": false,
                        "type": "invoke",
                        "verb": "put",
                        "params": []
                    },
                    {
                        "path": "",
                        "useBeforeImage": true,
                        "type": "delete",
                        "verb": "delete",
                        "params": [{
                            "name": "dsKLANT",
                            "type": "REQUEST_BODY"
                        }]
                    },
                    {
                        "name": "SubmitKlant",
                        "path": "\/SubmitKlant",
                        "useBeforeImage": true,
                        "type": "submit",
                        "verb": "put",
                        "params": [{
                            "name": "dsKlant",
                            "type": "REQUEST_BODY"
                        }]
                    },
                    {
                        "path": "",
                        "useBeforeImage": true,
                        "type": "create",
                        "verb": "post",
                        "params": [{
                            "name": "dsKlant",
                            "type": "REQUEST_BODY"
                        }]
                    }
                ]
            },
            {
                "name": "Land",
                "path": "\/Land",
                "autoSave": true,
                "schema": {
                    "type": "object",
                    "additionalProperties": false,
                    "properties": {"dsland": {
                        "type": "object",
                        "additionalProperties": false,
                        "properties": {"ttland": {
                            "type": "array",
                            "primaryKey": ["land"],
                            "items": {
                                "additionalProperties": false,
                                "properties": {
                                    "_id": {"type": "string"},
                                    "_errorString": {"type": "string"},
                                    "id": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "id"
                                    },
                                    "seq": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "seq"
                                    },
                                    "land": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Land"
                                    },
                                    "omschr": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Omschrijving"
                                    },
                                    "ISO3": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "ISO code"
                                    },
                                    "risico": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Risico"
                                    }
                                }
                            }
                        }}
                    }}
                },
                "operations": [
                    {
                        "path": "?filter={filter}",
                        "useBeforeImage": false,
                        "type": "read",
                        "verb": "get",
                        "params": []
                    },
                    {
                        "name": "count",
                        "path": "\/count?filter={filter}",
                        "useBeforeImage": false,
                        "type": "invoke",
                        "verb": "put",
                        "params": []
                    }
                ]
            },
            {
                "name": "Postcode",
                "path": "\/Postcode",
                "autoSave": true,
                "schema": {
                    "type": "object",
                    "additionalProperties": false,
                    "properties": {"dsPOST": {
                        "type": "object",
                        "additionalProperties": false,
                        "properties": {"ttPOST": {
                            "type": "array",
                            "primaryKey": [
                                "land",
                                "postcode",
                                "lknr"
                            ],
                            "items": {
                                "additionalProperties": false,
                                "properties": {
                                    "_id": {"type": "string"},
                                    "_errorString": {"type": "string"},
                                    "id": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "id"
                                    },
                                    "seq": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "seq"
                                    },
                                    "POST_OMS": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Gemeente"
                                    },
                                    "land": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Land"
                                    },
                                    "postcode": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "postcode"
                                    },
                                    "lknr": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Lk.Nr"
                                    },
                                    "regio": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Regio"
                                    },
                                    "CP_POST_OMS": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Gemeente voor Click and Post"
                                    }
                                }
                            }
                        }}
                    }}
                },
                "operations": [
                    {
                        "path": "?filter={filter}",
                        "useBeforeImage": false,
                        "type": "read",
                        "verb": "get",
                        "params": []
                    },
                    {
                        "name": "count",
                        "path": "\/count?filter={filter}",
                        "useBeforeImage": false,
                        "type": "invoke",
                        "verb": "put",
                        "params": []
                    }
                ]
            },
            {
                "name": "JuridischeVorm",
                "path": "\/JuridischeVorm",
                "autoSave": true,
                "schema": {
                    "type": "object",
                    "additionalProperties": false,
                    "properties": {"dsNBBVOJU": {
                        "type": "object",
                        "additionalProperties": false,
                        "properties": {"ttNBBVOJU": {
                            "type": "array",
                            "primaryKey": ["JUVO-CO"],
                            "items": {
                                "additionalProperties": false,
                                "properties": {
                                    "_id": {"type": "string"},
                                    "_errorString": {"type": "string"},
                                    "id": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "id"
                                    },
                                    "seq": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "seq"
                                    },
                                    "JUVO_CO": {
                                        "type": "integer",
                                        "ablType": "INTEGER",
                                        "default": 0,
                                        "title": "Code"
                                    },
                                    "JUVO_OM": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Afkorting"
                                    },
                                    "JUVO_NA": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Benaming"
                                    },
                                    "JUVO_OMFR": {
                                        "type": "string",
                                        "ablType": "CHARACTER",
                                        "default": "",
                                        "title": "Afkorting FR"
                                    }
                                }
                            }
                        }}
                    }}
                },
                "operations": [
                    {
                        "name": "count",
                        "path": "\/count?filter={filter}",
                        "useBeforeImage": false,
                        "type": "invoke",
                        "verb": "put",
                        "params": []
                    },
                    {
                        "path": "?filter={filter}",
                        "useBeforeImage": false,
                        "type": "read",
                        "verb": "get",
                        "params": []
                    }
                ]
            }
        ]
    }]
}


But when I try to assign object attributes (location) to the object, I only see the fields 'id', '_id' and '_errorstring':

All Replies

Posted by Shivani Silveri on 20-Mar-2016 01:55

Hi,

Have you tried skipping those fields while creating the Object?

While mapping the fields, please skip the fields that you want to use as the Location fields. Now, in the object definition page, you will be finding the skipped fields. Here, you can map them accordingly.

Hope this helps.

Thanks,

Shivani.

This thread is closed