Home: Genealogy:

Get Database Record in JSON: Help

This page describes the use of the script getRecordJson.php which is used to extract the content of database records in JavaScript Object Notation (JSON), to support external access to the internal content of the database.

The user must be signed in as a user to use this feature. The contents of the response to a request depends upon the level of authorization of the requesting user. In particular a requesting user can only see information that the user is authorized to see. For example private information about an individual in the family tree is only visible to members of that individual's family.

The record or records to be returned is specified by parameter passed by method "Get", that is by parameters passed as part of the Uniform Record Location (URL). The parameter names are case insensitive. For example you can specify "...?table=Picture" or "...?Table=Picture", "...&id=756" or "...&ID=756".

If you add the parameter "&debug=Y" to the query then the generated document will include a trace of how the response was generated. This trace is in HTML and may include characters that cause it to not be valid JSON.

The table to be examined is identified by the parameter "table", which can have one of the following case-sensitive values:

Addresses This table contains family tree records representing a fully structured address. For example this is used for the addresses of repositories. This table is implied if the IDAR parameter is specified. For further information see Addresses
PictureBases This table contains family tree records representing a folder on the Web which contains images.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
Pictures This table contains family tree records representing images.
Specific record identified by parameter 'id'.
You can search for a list of address records by specifying the any of the following, "idir", "idtype", "pictype", "picorder", "picname", "picnameurl", "idbppic", "piccaption", "picd", "picsd", "picdate", "picdesc", "picprint", "picsoundname", "picsoundnameurl", "idbpsound", "used", "picpref", "filingref". For example "?table=Picture&idtype=0&idir=5" displays all pictures associated with individual 5.
ChildParentRels This table contains types of relationships between children and parents.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
Children This table contains family tree records representing a child's relationship to a set of parents.
Specific record identified by parameter 'id'.
You can search for a list of address records by specifying one or more of the following parameters: "idmr", "idir", "order", "prefchild", "idcs", "idcpdad", "idcpmom", "cpdadprivate", "cpmomprivate", "parseald", "parsealsd", "idtrparseal", "parsealnote", "ldsp", "templetag". For example specifying "?table=Child&idmr=6" lists all children in family 6. For example "?table=Child&idir=10939" lists all families in which individual 10939 is a child.
ChildStatuses This table contains family tree records defining values of the field "idcs" in the Child table.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
DontMergeEntries This table contains family tree records representing pairs of individuals who should never be merged because they are known to be distinct even though very similar in name and birth date.
Specific record identified by parameter 'idirleft' and 'idirright'
Events This table contains family tree records representing facts or events about an individual or a family.
Specific record identified by parameter 'id'.
You can search for a list of event records by specifying one or more of the following parameters: "idir", "idet", "order", "eventd", "eventsd", "idlrevent", "desc", "gedtag", "eventexclude", "idtype", "idar", "description", "sentenceoverride", "qstag", "rgexclude", "kind", "ldstempleready", "preferred"
EventTypes This table contains family tree records representing values of event type.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
Bookmarks This table contains family tree records representing bookmarks.
Specific record identified by parameter 'id'. There are always 200 entries in this table, numbered 1 through 200.
HistoryList This table contains family tree records representing a history of the last 200 family tree individuals or families referenced by the system. This does not mean much when there are multiple users sharing the family tree so it is not maintained by the site.
Specific record identified by parameter 'id'. There are always 200 entries in this table, numbered 1 through 200.
Header This table contains family tree records representing information about the family tree database itself.
no parameters required. The complete table is always displayed.
Persons This table contains family tree records representing individuals in the family tree.
Specific record identified by parameter 'id'.
You can search for a list of location records by specifying one or more of the following parameters: "fsid", "surname", "soundslike", "givenname", "prefix", "title", "namenote", "gender", "birthd", "birthsd", "idlrbirth", "chrisd", "chrissd", "idlrchris", "chrterm", "deathd", "deathsd", "idlrdeath", "buriedd", "buriedsd", "idlrburied", "cremated", "idarbirth", "idarchris", "idardeath", "idarburied", "birthnote", "chrisnote", "deathnote", "buriednote", "living", "baptismd", "baptismsd", "baptismkind", "idtrbaptism", "baptismnote", "ldsb", "confirmationd", "confirmationsd", "confirmationkind", "idtrconfirmation", "confirmationnote", "ldsc", "initiatoryd", "initiatorysd", "idtrinitiatory", "initiatorynote", "ldsi", "endowd", "endowsd", "idtrendow", "endownote", "ldse", "templetag", "idmrpref", "idmrparents", "idar", "ancinterest", "decinterest", "tag1", "tag2", "tag3", "tag4", "tag5", "tag6", "tag7", "tag8", "tag9", "taggroup", "taganc", "tagdec", "savetag", "srchtag", "srchtagigi", "srchtagrg", "srchtagfs", "qstag", "remindertag", "remindertagdeath", "treenum", "ltmp1", "ltmp2", "alreadyused", "userref", "ancestralref", "notes", "references", "medical", "deathcause", "ppcheck", "imported", "added", "addedtime", "updated", "updatedtime", "relations", "nevermarried", "directline", "stmp1", "colortag", "intellishare", "private", "ppexclude", "rgexclude", "dna", "fssync", "fsdups", "fsordinance", "fslinks"
Locations This table contains family tree records representing locations associated with events or facts.
Specific record identified by parameter 'id'.
You can search for a list of location records by specifying one or more of the following parameters: "fsplaceid", "location", "used", "sortedlocation", "latitude", "longitude", "tag1", "shortname", "preposition", "notes", "verified", "fsresolved", "veresolved", "qstag", "zoom", "boundary".
Families This table contains family tree records representing a family.
Specific record identified by parameter 'id'.
You can search for a list of location records by specifying one or more of the following parameters: "idirhusb", "husborder", "husbprefmar", "husbsurname", "husbgivenname", "husbmarrsurname", "husbbirthsd", "idirwife", "wifeorder", "wifeprefmar", "wifesurname", "wifegivenname", "wifemarrsurname", "wifebirthsd", "marriednamerule", "idms", "mardc", "mard", "marsd", "marenddc", "marendd", "marendsd", "idlrmar", "marloc", "sealdc", "seald", "sealsd", "idtrseal", "sealloc", "sealnote", "ldss", "templetag", "tag1", "tag2", "tag3", "taggroup", "srchtag", "qstag", "remindertag", "notmarried", "nochildren", "alreadyused", "ltmp1", "ltmp2", "notes", "ppcheck", "added", "addedtime", "updated", "updatedtime", "idar", "hphrase", "wphrase", "rphrase", "rphrase2", "id", "tag4", "tag5", "tag6", "tag7", "tag8", "tag9", "userref", "mphrase", "sphrase", "husbwifeover1", "husbwifeover2", "wifehusbover1", "wifehusbover2", "private"
MarriageStatuses This table contains family tree records representing the set of marriage statuses.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
Surnames This table contains family tree records representing family names present in the database.
A specific record is identified by parameter 'surname=^surname$'.
You can search for a list of location records by specifying one or more of the following parameters: "surname", "soundslike", and "notes" use a pattern match. "used", "tag1", "qstag" are numeric values.
Names This table contains family tree records representing individual names of individuals in the database.
A specific record is identified by parameter 'id=number'.
You can search for a list of name records by specifying one or more of the following parameters. "surname", "soundslike", "givenname", "prefix", "title", "userref", and "treename" are pattern matches. "idir", "order", "marriednamecreatedby", "birthsd", "preferredaka", "akanote", "idmr", "srchtag", and "qstag" are numeric values.
Reminders This table contains family tree records representing reminders.
Specific record identified by parameter 'id'.
Sources This table contains family tree records representing documentary sources.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "srcname", "srctitle", "srcauthor", "srcpubl", "srctext", "srcnote", "srctag", "srcexclude", "idst", "used", "psrcnote", "fsrcnote", "tsrcnote", "psrctext", "fsrctext", "tsrctext", "idar", "enteredsd", "filingref", "srccallnum", "verified", "published", "enteredd", "qstag", "srcmpub", "srcrollnum", "templateid", "contents", "usestandard", "idar2", "bibliography", "override", "overridefootnote", "overridesubsequent", "overridebibliography". For example "?table=Source&srcname=Census" lists all sources whose name includes the word "Census".
SourceTypes This table contains family tree records representing types of sources.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
Citations This table contains family tree records representing citations to sources.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "idsr", "idime", "type", "srcdetail", "srcsurety", "srcprint", "srcprintdetail", "srcprinttext", "srcdettext", "srcdetnote", "srcprintnote", "enteredd", "enteredsd", "filingref", "order", "used", "verified", "content", "override", "overridefootnote", "overridesubsequent", "overridebibliography".
ToDoCategories This table contains family tree records representing categories of To-Do items.
Specific record identified by parameter 'id'. If this is omitted the complete table is displayed.
ToDoEntries This table contains family tree records representing actions to take in the future.
Specific record identified by parameter 'id'.
ToDoLocalities This table contains family tree records representing localities associated with To-Do items.
Specific record identified by parameter 'id'.
Temples This table contains family tree records representing LDS Temples at which ordinances take place.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "code", "code2", "temple", "templestart", "templeend", "used", "tag1", "qstag"
RemovedIndividuals This table contains family tree records representing record numbers of individuals that are no longer in use.
Specific record identified by parameter 'id'.
RemovedFamilies This table contains family tree records representing record numbers of families that are no longer in use.
Specific record identified by parameter 'id'.
Users This table contains representing registered users of the site. Only an administrator can view this table.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "username", "password", "shapassword", "email", "auth", "id", "options"
Blogs This table contains family tree records representing blog entries associated with any record in the database.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "index", "datetime", "username", "bl_table", "keyname", "keyvalue", "text"
MethodistBaptisms This table contains family tree records representing Baptism records, particularly as maintained by the Wesleyan Methodist Church in Canada.
Specific record identified by parameter 'id'.
You can search for a list of source records by specifying one or more of the following parameters: "volume", "page", "district", "area", "givenname", "surname", "father", "mother", "residence", "birthplace", "birthdate", "baptismdate", "baptismplace", "minister", "idir"
Births This table contains family tree records representing birth registrations.
Specific record identified by parameter 'domain', 'year', 'regnum'
Deaths This table contains family tree records representing death registrations.
Specific record identified by parameter 'domain', 'year', 'regnum'
Marriages This table contains family tree records representing marriage registrations.
Specific record identified by parameter 'domain', 'year', 'regnum'
CountyMarriages This table contains family tree records representing marriages registered in Ontario prior to confederation which use a different system of identification than those after confederation.
Specific record identified by parameter 'Domain', 'Volume', 'ReportNo', 'ItemNo'
You can search for a list of source records by specifying one or more of the following parameters: "volume", "reportno", "domain"
CountyMarriageReports This table contains family tree records representing annual reports from clergymen.
Specific record identified by parameter 'Domain', 'Volume', 'ReportNo'.
You can search for a list of source records by specifying one or more of the following parameters: "volume", "domain"
Counties This table contains family tree records representing counties within a state or province.
Specific record identified by parameter 'domain', 'county'
For further information see Counties
Townships This table contains family tree records representing townships within a county.
Specific record identified by parameter 'domain', 'county', 'code'
You can search for a list of townships by specifying one or more of the following parameters" "domain", and "county".
Censuses This table contains records representing censuses that are supported for citations by transcriptions.
Specific record identified by parameter 'censusid'. All census records are displayed if no parameters are specified.
You can search for a list of censuses by specifying one or more of the following parameters: "name", "linesperpage", "collective", "provinces". For further information see Censuses
Districts This table contains records representing enumeration districts into which a census is divided for administration.
Specific record identified by parameters 'censusid', 'district'.
You can search for a list of districts by specifying one or more of the following parameters: "censusid", "name", "nom", "province", "population".
SubDistricts This table contains records representing enumeration divisions within a census.
Specific record identified by parameter 'censusid', 'district', 'subdistrict', 'division'.
You can search for a list of sub-district records by ommitting "division" and optionally "subdistrict".
Pages This table contains records representing individual pages within a census.
Specific record identified by parameter "censusid", "district", "subdistrict", "division", "page".
You can search for a list of page records by ommitting the "page" parameter.
Census1851 These tables contain records transcribed from specific censuses.
Specific record identified by parameters "district", "subdistrict", "division", "page", and "line". For pre-confederation censuses the "province" must also be specified, for example "&province=CW".
You can search for a list of source records by specifying any field names within the census. For example "?table=Census1881&givennames=John&surname=Smith".
Census1861
Census1871
Census1881
Census1891
Census1901
Census1906
Census1911
Census1916
Census1921
James Cobban Logo Contact Author
Home: Genealogy: