{"type":"doc","content":[{"type":"paragraph","content":[{"text":"With this method, the whole response from the API is returned. You can change the target of the response in ","type":"text"},{"text":"outputTarget","type":"text","marks":[{"type":"code"}]},{"text":" (body, header, property) and ","type":"text"},{"text":"outputtargetName","type":"text","marks":[{"type":"code"}]},{"text":" (name for header, property). ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"cae3c8c9-1a09-414c-adfa-4c973dea1e0c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"Option","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"Default","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"outputTarget","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines output target for data in the exchange. It can be stored in the header, property or body.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"outputTargetName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines output target name for the target type header and property. Put here the name of exchange header and name of exchange property.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"massEditFields","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines fields for mass edit, separated by a semicolon. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"dataSourceName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Name of the Data Source.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"objectType","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines the object type, e.g. DM, DMDS, Q, LTV, P, PX.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"mapper","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines mapper name which is a Spring bean or a definition in the header or property.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"valueFields","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Contains strings separated by a comma that specify one or more fields to be returned. If omitted, all fields are returned. The server fetches only these valueFields from the database, so it generally gives a better performance. The result object is then sent as a list of fields instead of a Map. Compare with ","type":"text"},{"text":"resultFields","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"resultFields","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Contains strings separated by a comma that specify one or more fields to be returned. If omitted, all fields are returned. But the server still fetches all the fields from the database. The result object is sent as a Map. Compare with ","type":"text"},{"text":"valueFields","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"sql","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Optional parameter. Can be used instead of a regular table filter. Accepts an SQL-like syntax to define a filter logic. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Example: ","type":"text"},{"text":"'SELECT a WHERE b < 1 OR a <= 3 AND x > 1 ORDER BY a ASC'","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"The From clause has to be omitted – it has no meaning in filter API. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"connection","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines connection to Pricefx. This is an optional parameter and if it is not mentioned, the connection is taken from the Spring bean named ","type":"text"},{"text":"pricefx","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"pricingParameterName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"pricingParameterId","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"mapper","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines mapper name which is a Spring bean or a definition in the header or property.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"filter","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines the sorting. It overrides ","type":"text"},{"text":"sortBy","type":"text","marks":[{"type":"code"}]},{"text":" from a filter. Allows expression value (groovy, simple, constant).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"sortBy","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"sting","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Sort by. It overrides ","type":"text"},{"text":"sortBy","type":"text","marks":[{"type":"code"}]},{"text":" from a filter.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[177.0]},"content":[{"type":"paragraph","content":[{"text":"customFilterExpression","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[115.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[933.0]},"content":[{"type":"paragraph","content":[{"text":"Defines a custom filter expression. It allows for more advanced filtering, for example ","type":"text"},{"text":"customFilterExpression=attribute1>attribute2","type":"text","marks":[{"type":"code"}]},{"text":" filters all rows where the value in the ","type":"text"},{"text":"attribute1","type":"text","marks":[{"type":"code"}]},{"text":" column is greater than values in the ","type":"text"},{"text":"attribute2","type":"text","marks":[{"type":"code"}]},{"text":" column.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Examples","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Defining Fields","type":"text"}]},{"type":"paragraph","content":[{"text":"Fields are defined by the parameter ","type":"text"},{"text":"massEditFields","type":"text","marks":[{"type":"code"}]},{"text":" of ","type":"text"},{"text":"pfx-api:massedit","type":"text","marks":[{"type":"code"}]},{"text":". The format is following: fields are separated by ","type":"text"},{"text":",","type":"text","marks":[{"type":"code"}]},{"text":" and pairs name/value are separated by ","type":"text"},{"text":";","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Example:","type":"text"}]},{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" to define a field ","type":"text"},{"text":"attribute40","type":"text","marks":[{"type":"code"}]},{"text":" with a value ","type":"text"},{"text":"Y","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" to define fields ","type":"text"},{"text":"attribute40","type":"text","marks":[{"type":"code"}]},{"text":" with a value ","type":"text"},{"text":"Y","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"attribute41","type":"text","marks":[{"type":"code"}]},{"text":" with a value ","type":"text"},{"text":"N","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Datamart massedit Example","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"You can either set directly the parameter ","type":"text"},{"text":"typedId","type":"text","marks":[{"type":"code"}]},{"text":", or you can set ","type":"text"},{"text":"datasourceName","type":"text","marks":[{"type":"code"}]},{"text":". If you pick the latter, there will be one more call to the partition to get ","type":"text"},{"text":"typedId","type":"text","marks":[{"type":"code"}]},{"text":" from ","type":"text"},{"text":"datasourceName","type":"text","marks":[{"type":"code"}]},{"text":". Otherwise, the mass edit functionality is the same.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Standard massedit Example","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":" \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported