Retrieve User Extension Fields Definitions By Code

25 Sep 2024
2 Minutes to read

Print
Dark
Light

Retrieve User Extension Fields Definitions By Code

Updated on 25 Sep 2024
2 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/sys-rest-api/rest/1/sdobjusrextdef

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select by Row Finder
By UUID

Select by Row Finder

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
TableName	Table Name	DMWORKORDERS_V
AuditDate	Create or Update Date Time Filter	2016-01-01

By UUID

This is an optional finder for querying a specific User Extension Fields Definition by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/sys-rest-api/rest/1/sdobjusrextdef/E7D0D88648EF3B18E05316821FACBD1B

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleRowFinder; TableName=DMWORKORDERS_V, AuditDate=2015-01-01

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleUedSchemaName:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "UedSchemaName": "DA",
      "UedTableName": "DMWORKORDERS_V",
      "UedCode1Code": "MAN#",
      "UedCode2Code": null,
      "UedCode3Code": null,
      "UedCode4Code": null,
      "UedCode5Code": null,
      "UedCode6Code": null,
      "UedCode7Code": null,
      "UedCode8Code": null,
      "UedCode9Code": null,
      "UedCode10Code": null,
      "UedCode11Code": null,
      "UedCode12Code": null,
      "UedCode13Code": null,
      "UedCode14Code": null,
      "UedCode15Code": null,
      "UedCode16Code": null,
      "UedCode17Code": null,
      "UedCode18Code": null,
      "UedCode19Code": null,
      "UedCode20Code": null,
      "UedNum1Code": null,
      "UedNum2Code": null,
      "UedNum3Code": null,
      "UedNum4Code": null,
      "UedNum5Code": null,
      "UedNum6Code": null,
      "UedNum7Code": null,
      "UedNum8Code": null,
      "UedNum9Code": null,
      "UedNum10Code": null,
      "UedNum11Code": null,
      "UedNum12Code": null,
      "UedNum13Code": null,
      "UedNum14Code": null,
      "UedNum15Code": null,
      "UedNum16Code": null,
      "UedNum17Code": null,
      "UedNum18Code": null,
      "UedNum19Code": null,
      "UedNum20Code": null,
      "UedDate1Code": null,
      "UedDate2Code": null,
      "UedDate3Code": null,
      "UedDate4Code": null,
      "UedDate5Code": null,
      "UedDate6Code": null,
      "UedDate7Code": null,
      "UedDate8Code": null,
      "UedDate9Code": null,
      "UedDate10Code": null,
      "UedDate11Code": null,
      "UedDate12Code": null,
      "UedDate13Code": null,
      "UedDate14Code": null,
      "UedDate15Code": null,
      "UedDate16Code": null,
      "UedDate17Code": null,
      "UedDate18Code": null,
      "UedDate19Code": null,
      "UedDate20Code": null,
      "UedIuCreateDate": "2015-08-28T03:40:54Z",
      "UedIuUpdateDate": null,
      "UedCode21Code": null,
      "UedCode22Code": null,
      "UedCode23Code": null,
      "UedCode24Code": null,
      "UedCode25Code": null,
      "UedCode26Code": null,
      "UedCode27Code": null,
      "UedCode28Code": null,
      "UedCode29Code": null,
      "UedCode30Code": null,
      "UedCode31Code": null,
      "UedCode32Code": null,
      "UedCode33Code": null,
      "UedCode34Code": null,
      "UedCode35Code": null,
      "UedCode36Code": null,
      "UedCode37Code": null,
      "UedCode38Code": null,
      "UedCode39Code": null,
      "UedCode40Code": null,
      "UedCode41Code": null,
      "UedCode42Code": null,
      "UedCode43Code": null,
      "UedCode44Code": null,
      "UedCode45Code": null,
      "UedCode46Code": null,
      "UedCode47Code": null,
      "UedCode48Code": null,
      "UedCode49Code": null,
      "UedCode50Code": null,
      "UedCode51Code": null,
      "UedCode52Code": null,
      "UedCode53Code": null,
      "UedCode54Code": null,
      "UedCode55Code": null,
      "UedCode56Code": null,
      "UedCode57Code": null,
      "UedCode58Code": null,
      "UedCode59Code": null,
      "UedCode60Code": null,
      "UedCode61Code": null,
      "UedCode62Code": null,
      "UedCode63Code": null,
      "UedCode64Code": null,
      "UedCode65Code": null,
      "UedCode66Code": null,
      "UedCode67Code": null,
      "UedCode68Code": null,
      "UedCode69Code": null,
      "UedCode70Code": null,
      "UedCode71Code": null,
      "UedCode72Code": null,
      "UedCode73Code": null,
      "UedCode74Code": null,
      "UedCode75Code": null,
      "UedCode76Code": null,
      "UedCode77Code": null,
      "UedCode78Code": null,
      "UedCode79Code": null,
      "UedCode80Code": null,
      "UedCode81Code": null,
      "UedCode82Code": null,
      "UedCode83Code": null,
      "UedCode84Code": null,
      "UedCode85Code": null,
      "UedCode86Code": null,
      "UedCode87Code": null,
      "UedCode88Code": null,
      "UedCode89Code": null,
      "UedCode90Code": null,
      "UedCode91Code": null,
      "UedCode92Code": null,
      "UedCode93Code": null,
      "UedCode94Code": null,
      "UedCode95Code": null,
      "UedCode96Code": null,
      "UedCode97Code": null,
      "UedCode98Code": null,
      "UedCode99Code": null,
      "UedCode100Code": null,
      "UedVUuid": "E7D0D88648EF3B18E05316821FACBD1B",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/sdobjusrextdef/E7D0D88648EF3B18E05316821FACBD1B",
          "name": "sdobjusrextdef",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/sdobjusrextdef/E7D0D88648EF3B18E05316821FACBD1B",
          "name": "sdobjusrextdef",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/sys-rest-api/rest/1/sdobjusrextdef",
      "name": "sdobjusrextdef",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create Valid Field Data

Retrieve User Extension Fields Definitions By Code

Query Standards

Finder

Select by Row Finder

By UUID

What's Next

Contact Us