API V1 - ChannelMappings

ChannelMappings Endpoint

https://api.welldatalabs.com/ChannelMappings/{JobId}

ChannelMapping Object

ChannelMappings returns all available data for mapped and unmapped columns within a single job. Source Channel is the name of the column as it appears in the raw file. Unit is the standardized unit name that will match the unit that the column displays with in Well Data Labs (for example, if the unit is “gallon/1000” in the raw file, it will return with “gal/mgal”), and will return “none” if no unit exists or if the column has a unit that is not recognized by Well Data Labs. Type, Subtype, and Channel will either be null or contain information that has been mapped to the column in Well Data Labs. File column index is a unique sorting integer and can be used to differentiate among columns with identical names within the same file. JobId is a string value that Well Data Labs uses to uniquely identify a job. Modified UTC is when the channel or mapping was last modified.

Here is the shape of the ChannelMapping object.

{
        "sourceChannel": <Channel name as originally imported>
        "channel": <Well Data Labs name for Global Field or Pick List item>
        "unit": <Well Data Labs standardized name for the unit>
        "type": <Global Field, Fluid, Chemical, Proppant, etc...>
        "subType": <Friction Reducer, Breaker, etc...>
        "fileColumnIndex": <Well Data Labs sorting index of the channel>
        "jobId": <Well Data Labs unique id for this job>
        "modifiedUtc": <UTC time of last change to mapping or channel>
}

Here is a fully populated ChannelMapping object.

[
    {
        "sourceChannel": "Job Time",
        "channel": "Job Time",
        "unit": "hh:mm:ss",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 0,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:16:58.513"
    },
    {
        "sourceChannel": "Elapsed Time",
        "channel": null,
        "unit": "min",
        "type": null,
        "subType": null,
        "fileColumnIndex": 1,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:16:58.523"
    },
    {
        "sourceChannel": "Treating Pressure",
        "channel": "Treating Pressure",
        "unit": "psi",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 2,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.253"
    },
    {
        "sourceChannel": "Surface Pressure",
        "channel": "Surface Pressure",
        "unit": "psi",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 3,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.283"
    },
    {
        "sourceChannel": "Calc Bottom Hole Pressure",
        "channel": "Bottomhole Pressure",
        "unit": "psi",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 4,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.3"
    },
    {
        "sourceChannel": "Clean Volume",
        "channel": "Clean Volume",
        "unit": "bbl",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 5,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:18:00.527"
    },
    {
        "sourceChannel": "Slurry Rate",
        "channel": null,
        "unit": "bpm",
        "type": null,
        "subType": null,
        "fileColumnIndex": 6,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:16:58.53"
    },
    {
        "sourceChannel": "Slurry Volume",
        "channel": "Slurry Volume",
        "unit": "bbl",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 7,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:18:02.49"
    },
    {
        "sourceChannel": "BH Proppant Concentration",
        "channel": "Bottomhole Proppant Conc",
        "unit": "lbs/gal",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 8,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:18:18.063"
    },
    {
        "sourceChannel": "Proppant Concentration",
        "channel": "Proppant Conc",
        "unit": "lbs/gal",
        "type": "Global Field",
        "subType": null,
        "fileColumnIndex": 9,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:18:15.403"
    },
    {
        "sourceChannel": "Gel Viscosity",
        "channel": null,
        "unit": "cp",
        "type": null,
        "subType": null,
        "fileColumnIndex": 10,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:16:58.533"
    },
    {
        "sourceChannel": "Crosslinker",
        "channel": "XL-13-Crosslinker",
        "unit": "gal/mgal",
        "type": "Chemical",
        "subType": "Crosslinker",
        "fileColumnIndex": 11,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.423"
    },
    {
        "sourceChannel": "Breaker",
        "channel": "GBW-5-Breaker",
        "unit": "gal/mgal",
        "type": "Chemical",
        "subType": "Breaker",
        "fileColumnIndex": 12,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.477"
    },
    {
        "sourceChannel": "Activator",
        "channel": "Cat-3-Activator",
        "unit": "gal/mgal",
        "type": "Chemical",
        "subType": "Activator",
        "fileColumnIndex": 13,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.517"
    },
    {
        "sourceChannel": "Non-Emulsifier",
        "channel": null,
        "unit": "gal/mgal",
        "type": null,
        "subType": null,
        "fileColumnIndex": 14,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:16:58.537"
    },
    {
        "sourceChannel": "Friction Reducer",
        "channel": "EXCELERATE PS-2-Friction Reducer",
        "unit": "gal/mgal",
        "type": "Chemical",
        "subType": "Friction Reducer",
        "fileColumnIndex": 15,
        "jobId": "b332c113-3397-4379-8ab7-302efc3ae949",
        "modifiedUtc": "2017-06-20T21:17:05.573"
    }
]

HTTP Response Status Codes

Status Code Description
200 Successful request and data was returned in the body
400 JobId or APINumber not valid or missing.
404 No results found. Note that the endpoint was found, we just didn't find any data matching the criteria.
500 Unexpected error

GET https://api.welldatalabs.com/ChannelMappings/{Id}

A GET request must include a JobId and will return a list of all channels with their associated mappings.

curl https://api.welldatalabs.com/ChannelMappings/b332c113-3397-4379-8ab7-302efc3ae949- --header "Authorization: Bearer b+S15uKWEK0lFU+NomEmvekn8yk/ALTTBAYOJalVKrI="
Id Parameters

Id Description
JobId Well Data Labs assigned Job Id; e.g. 5000e906-9c4e-47bc-87a2-128d278e5ae9