Not all fields from OpenEdge Service object shown when assigning object attributes - Forum - Rollbase - Progress Community

Not all fields from OpenEdge Service object shown when assigning object attributes

 Forum

Not all fields from OpenEdge Service object shown when assigning object attributes

  • 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':

  • 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.