GET Performs arithmetic,geometric,aggregate and string operations on column(s) of a dataset passed as an input.

Exact public source snapshot

This operation is retained because its version-labelled public specification differs structurally from another generation. It is comparison evidence, not a promise of current support, compatibility, entitlement, or availability.

Request target

Call the operation

GET

https://mgis-apiv2.mappls.com/dqv/expression?queryType=arithmetic&datasetNme=india&operator=replace&col=district%2Cbank&type=view

Base URLhttps://mgis-apiv2.mappls.com/

Authenticationbearer

Journey roleobserve

Content typesNo request body

Path, query, and headers

Parameters

NameLocationTypeDescriptionExample

queryTyperequired

querystring

queryType values can be arithmetic,string,geometric and aggregate. On the basis of queryType value API can find which type of query you want to execute.

arithmetic

datasetNmerequired

querystring

The dataset name of whose information has to be fetched.

india

operatorrequired

querystring

Operator can contain the value of arithmetic,string,aggregate,geometric. Arithmetic Operators -,+,/, String Operators = Length,Upper,Lower,InitCap,Concat,Replace,Substring Aggregate Operators = Count, Average, Max, Median, Min, StdDev, Sum and distinct Geometric Operators = Lat,Long,Centroid,Area,Length

replace

colrequired

querystring

Single/Multiple column names on which the querytype operations has to be performed. In case of Querytype Geometric and geometric operators and String Operator(substring) single column value is required.

district,bank

typerequired

querystring

This parameter consists the type of property. Properties are - Create, View, Update. In case of Create We need new column. In case of View, newcolumn is not required and the data after operation will be shown in response. In case of Update the values get updated in the col of the table. In case of Geometric Operations UPDATE method/type are not applicable. In case of Aggregate Operations CREATE and UPDATE methods/types are not applicable.

view

new_column

querystring

newcolumn parameter is only mandatory in case of Type:Create, which is the name of new column to be created

updated_values

filter

querystring

Filter is the query to be applied on the dataset.

district in ( 'Bikaner','Churu')values

delimiter

querystring

A delimiter is a sequence of one or more characters for specifying the boundary between separate, independent regions in plain text, mathematical expressions or other data streams. An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values.[Note: Delimiter is applicable when when multiple column names have been added and its value always be in single inverted comma.]

'_'

oldData

querystring

oldData is the existing value which can be replaced.

Bikaner

newData

querystring

New Value that needs to be replaced with an existing value.

Delhi

start

querynumber

starting index of substring.

2

steps

querynumber

number of characters in the substring. If steps is blank then substring will contain characters from starting value provided to end of string.

5

groupBy

querystring

Pass the column names list which you want to display in the resultant. In case of multiple attributes passed in the groupBy parameter, by default it will take the first column for group by. In case of Aggregate Operation user can pass single/multiple attribute. In case of String and Arithmetic Operations groupBy, In case of multiple attributes passed in the groupBy parameter, by default it will take the first column for group by. In case of Geometric Operation groupBy is not applicable.

household

distinct

querystring

Distinct parameter is used when user want to get unique values of single/multiple columns of a dataset. Boolean values True and false can be passed. It is mandatory parameter when operator is distinct with queryType = aggregate.

true

Interactive, local, and credential-safe

Build your request in eight languages

Change source-backed examples once, validate required inputs, and copy the synchronized cURL, JavaScript, Python, Java, C#, Go, PHP, or Ruby request. Credentials remain environment references, and this page never sends a provider request.

Local request composerCode stays local · fixtures are explicit

GETRequest inputs

14 editable · 0 protected

queryTyperequiredqueryqueryType values can be arithmetic,string,geometric and aggregate. On the basis of queryType value API can find which type of query you want to execute.datasetNmerequiredqueryThe dataset name of whose information has to be fetched.operatorrequiredqueryOperator can contain the value of arithmetic,string,aggregate,geometric. Arithmetic Operators -,+,/, String Operators = Length,Upper,Lower,InitCap,Concat,Replace,Substring Aggregate Operators = Count, Average, Max, Median, Min, StdDev, Sum and distinct Geometric Operators = Lat,Long,Centroid,Area,LengthcolrequiredquerySingle/Multiple column names on which the querytype operations has to be performed. In case of Querytype Geometric and geometric operators and String Operator(substring) single column value is required.typerequiredqueryThis parameter consists the type of property. Properties are - Create, View, Update. In case of Create We need new column. In case of View, newcolumn is not required and the data after operation will be shown in response. In case of Update the values get updated in the col of the table. In case of Geometric Operations UPDATE method/type are not applicable. In case of Aggregate Operations CREATE and UPDATE methods/types are not applicable.new_columnquerynewcolumn parameter is only mandatory in case of Type:Create, which is the name of new column to be createdfilterqueryFilter is the query to be applied on the dataset.delimiterqueryA delimiter is a sequence of one or more characters for specifying the boundary between separate, independent regions in plain text, mathematical expressions or other data streams. An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values.[Note: Delimiter is applicable when when multiple column names have been added and its value always be in single inverted comma.]oldDataqueryoldData is the existing value which can be replaced.newDataqueryNew Value that needs to be replaced with an existing value.startquerystarting index of substring.stepsquerynumber of characters in the substring. If steps is blank then substring will contain characters from starting value provided to end of string.groupByqueryPass the column names list which you want to display in the resultant. In case of multiple attributes passed in the groupBy parameter, by default it will take the first column for group by. In case of Aggregate Operation user can pass single/multiple attribute. In case of String and Arithmetic Operations groupBy, In case of multiple attributes passed in the groupBy parameter, by default it will take the first column for group by. In case of Geometric Operation groupBy is not applicable.distinctqueryDistinct parameter is used when user want to get unique values of single/multiple columns of a dataset. Boolean values True and false can be passed. It is mandatory parameter when operator is distinct with queryType = aggregate.

Generated in eight languages

Environment-backed credentials

GET

https://mgis-apiv2.mappls.com/dqv/expression?queryType=arithmetic&datasetNme=india&operator=replace&col=district%2Cbank&type=view&new_column=updated_values&filter=district+in+%28+%27Bikaner%27%2C%27Churu%27%29values&delimiter=%27_%27&oldData=Bikaner&newData=Delhi&start=2&steps=5&groupBy=household&distinct=true

Credential-free sandboxExecute this contract without a provider call

How fixtures work

Generated from your inputs

curl --request GET \
  --url 'https://mgis-apiv2.mappls.com/dqv/expression?queryType=arithmetic&datasetNme=india&operator=replace&col=district%2Cbank&type=view&new_column=updated_values&filter=district+in+%28+%27Bikaner%27%2C%27Churu%27%29values&delimiter=%27_%27&oldData=Bikaner&newData=Delhi&start=2&steps=5&groupBy=household&distinct=true' \
  --header "Accept: application/json" \
  --header "Authorization: Bearer ${MAPPLS_ACCESS_TOKEN}"

Credential-safe by constructionSet MAPPLS_ACCESS_TOKEN only in your trusted runtime. Code generation stays local. Sandbox execution sends only bounded fixture inputs to this developer platform and never reads a credential or calls Mappls.

Five language quickstarts

Send a production-shaped request

Examples use environment-backed access tokens, explicit timeouts where supported, status checks, and JSON bodies derived from the source schema. Replace sample identifiers and coordinates with values from your application.

GET /dqv/expression

curl --request GET \
  --url 'https://mgis-apiv2.mappls.com/dqv/expression?queryType=arithmetic&datasetNme=india&operator=replace&col=district%2Cbank&type=view' \
  --header 'Authorization: Bearer YOUR_ACCESS_TOKEN'

Success and failure behavior

Responses

200

400

Bad Request, User made an error while creating a valid request.

404

No data found in database.

422

Parameter missing

500

Internal server error.

200 response fields

FieldTypeDescriptionExample

code

string

Response Code

200

success

string