ReconciliationReportRowService (v201808)

Provides methods for retrieving and updating the ReconciliationReportRow objects.

---

Production WSDL

https://ads.google.com/apis/ads/publisher/v201808/ReconciliationReportRowService?wsdl

Namespace

https://www.google.com/apis/ads/publisher/v201808

Operations

• getReconciliationReportRowsByStatement
• updateReconciliationReportRows

Errors

• ApiVersionError
• AuthenticationError
• CollectionSizeError
• CommonError
• FeatureError
• InternalApiError
• NotNullError
• NullError
• ParseError
• PermissionError
• PublisherQueryLanguageContextError
• PublisherQueryLanguageSyntaxError
• QuotaError
• RangeError
• ReconciliationError
• ReconciliationImportError
• RequiredCollectionError
• RequiredError
• ServerError
• StatementError
• StringFormatError
• StringLengthError

getReconciliationReportRowsByStatement

Gets a ReconciliationReportRowPage of ReconciliationReportRow objects that satisfy the given Statement.query. The following fields are supported for filtering:

PQL Property	Object Property
reconciliationReportId	ReconciliationReportRow.reconciliationReportId
advertiserId	ReconciliationReportRow.advertiserId
orderId	ReconciliationReportRow.orderId
lineItemId	ReconciliationReportRow.lineItemId
proposalLineItemId	ReconciliationReportRow.proposalLineItemId
creativeId	ReconciliationReportRow.creativeId
lineItemCostType	ReconciliationReportRow.lineItemCostType
dfpClicks	ReconciliationReportRow.dfpClicks
dfpImpressions	ReconciliationReportRow.dfpImpressions
dfpLineItemDays	ReconciliationReportRow.dfpLineItemDays
thirdPartyClicks	ReconciliationReportRow.thirdPartyClicks
thirdPartyImpressions	ReconciliationReportRow.thirdPartyImpressions
thirdPartyLineItemDays	ReconciliationReportRow.thirdPartyLineItemDays
manualClicks	ReconciliationReportRow.manualClicks
manualImpressions	ReconciliationReportRow.manualImpressions
manualLineItemDays	ReconciliationReportRow.manualLineItemDays
reconciledClicks	ReconciliationReportRow.reconciledClicks
reconciledImpressions	ReconciliationReportRow.reconciledImpressions
reconciledLineItemDays	ReconciliationReportRow.reconciledLineItemDays

The reconciliationReportId field is required and can only be combined with an AND to other conditions. Furthermore, the results may only belong to one ReconciliationReport.

Parameters

Field	Type	Description
filterStatement	Statement	a Publisher Query Language statement used to filter a set of reconciliation report rows

Response

Field	Type	Description
rval	ReconciliationReportRowPage	the reconciliation report rows that match the given filter

updateReconciliationReportRows

Updates a list of ReconciliationReportRow which belong to same ReconciliationReport.

Parameters

Field	Type	Description
reconciliationReportRows	ReconciliationReportRow[]	a list of reconciliation report rows to update

Response

Field	Type	Description
rval	ReconciliationReportRow[]	the updated reconciliation report rows

Errors

Error	Reasons
ApiVersionError	Errors related to the usage of API versions. Enumerations UPDATE_TO_NEWER_VERSION Indicates that the operation is not allowed in the version the request was made in. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
AuthenticationError	An error for an exception that occurred when authenticating. Enumerations AMBIGUOUS_SOAP_REQUEST_HEADER The SOAP message contains a request header with an ambiguous definition of the authentication header fields. This means either the authToken and oAuthToken fields were both null or both were specified. Exactly one value should be specified with each request. INVALID_EMAIL The login provided is invalid. AUTHENTICATION_FAILED Tried to authenticate with provided information, but failed. INVALID_OAUTH_SIGNATURE The OAuth provided is invalid. INVALID_SERVICE The specified service to use was not recognized. MISSING_SOAP_REQUEST_HEADER The SOAP message is missing a request header with an authToken and optional networkCode. MISSING_AUTHENTICATION_HTTP_HEADER The HTTP request is missing a request header with an authToken MISSING_AUTHENTICATION The request is missing an authToken NOT_WHITELISTED_FOR_API_ACCESS The customer is not whitelisted for API access. NO_NETWORKS_TO_ACCESS The user is not associated with any network. NETWORK_NOT_FOUND No network for the given networkCode was found. NETWORK_CODE_REQUIRED The user has access to more than one network, but did not provide a networkCode. CONNECTION_ERROR An error happened on the server side during connection to authentication service. GOOGLE_ACCOUNT_ALREADY_ASSOCIATED_WITH_NETWORK The user tried to create a test network using an account that already is associated with a network. UNDER_INVESTIGATION The account is blocked and under investigation by the collections team. Please contact Google for more information. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
CollectionSizeError	Error for the size of the collection being too large Enumerations TOO_LARGE UNKNOWN The value returned if the actual value is not exposed by the requested API version.
CommonError	A place for common errors that can be used across services. Enumerations NOT_FOUND Indicates that an attempt was made to retrieve an entity that does not exist. ALREADY_EXISTS Indicates that an attempt was made to create an entity that already exists. NOT_APPLICABLE Indicates that a value is not applicable for given use case. DUPLICATE_OBJECT Indicates that two elements in the collection were identical. CANNOT_UPDATE Indicates that an attempt was made to change an immutable field. CONCURRENT_MODIFICATION Indicates that another request attempted to update the same data in the same network at about the same time. Please wait and try the request again. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
FeatureError	Errors related to feature management. If you attempt using a feature that is not available to the current network you'll receive a FeatureError with the missing feature as the trigger. Enumerations MISSING_FEATURE A feature is being used that is not enabled on the current network. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
InternalApiError	Indicates that a server-side error has occured. InternalApiErrors are generally not the result of an invalid request or message sent by the client. Enumerations UNEXPECTED_INTERNAL_API_ERROR API encountered an unexpected internal error. TRANSIENT_ERROR A temporary error occurred during the request. Please retry. UNKNOWN The cause of the error is not known or only defined in newer versions. DOWNTIME The API is currently unavailable for a planned downtime. ERROR_GENERATING_RESPONSE Mutate succeeded but server was unable to build response. Client should not retry mutate.
NotNullError	Caused by supplying a null value for an attribute that cannot be null. Enumerations ARG1_NULL Assuming that a method will not have more than 3 arguments, if it does, return NULL ARG2_NULL ARG3_NULL NULL UNKNOWN The value returned if the actual value is not exposed by the requested API version.
NullError	Errors associated with violation of a NOT NULL check. Enumerations NULL_CONTENT Specified list/container must not contain any null elements
ParseError	Lists errors related to parsing. Enumerations UNPARSABLE Indicates an error in parsing an attribute. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
PermissionError	Errors related to incorrect permission. Enumerations PERMISSION_DENIED User does not have the required permission for the request. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
PublisherQueryLanguageContextError	An error that occurs while executing a PQL query contained in a Statement object. Enumerations UNEXECUTABLE Indicates that there was an error executing the PQL. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
PublisherQueryLanguageSyntaxError	An error that occurs while parsing a PQL query contained in a Statement object. Enumerations UNPARSABLE Indicates that there was a PQL syntax error. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
QuotaError	Describes a client-side error on which a user is attempting to perform an action to which they have no quota remaining. Enumerations EXCEEDED_QUOTA The number of requests made per second is too high and has exceeded the allowable limit. The recommended approach to handle this error is to wait about 5 seconds and then retry the request. Note that this does not guarantee the request will succeed. If it fails again, try increasing the wait time. Another way to mitigate this error is to limit requests to 8 per second for Ad Manager 360 accounts, or 2 per second for Ad Manager accounts. Once again this does not guarantee that every request will succeed, but may help reduce the number of times you receive this error. UNKNOWN The value returned if the actual value is not exposed by the requested API version. REPORT_JOB_LIMIT This user has exceeded the allowed number of new report requests per hour (this includes both reports run via the UI and reports run via ReportService.runReportJob). The recommended approach to handle this error is to wait about 10 minutes and then retry the request. Note that this does not guarantee the request will succeed. If it fails again, try increasing the wait time. Another way to mitigate this error is to limit the number of new report requests to 250 per hour per user. Once again, this does not guarantee that every request will succeed, but may help reduce the number of times you receive this error.
RangeError	A list of all errors associated with the Range constraint. Enumerations TOO_HIGH TOO_LOW UNKNOWN The value returned if the actual value is not exposed by the requested API version.
ReconciliationError	Lists all errors associated with reconciliation. Enumerations CANNOT_CREATE_RECONCILIATION_REPORT_VERSION Reconciliation report is reconciled, and need to revert. Or reconciliation report is Deleted, and not possible. INVALID_RECONCILIATION_REPORT_STATE_TRANSITION Reconciliation report can't be put into that reconciliation state. INVALID_RECONCILIATION_PROPOSAL_SUBMISSION_SEQUENCE Previous cycles of the proposal must be reconciled first. USER_CANNOT_RECONCILE_RECONCILIATION_REPORT User does not have permission to put reconciliation report into reconciled state. CONTRACTED_VOLUME_CANNOT_BE_NULL The billed from is contracted, but the contracted volume cannot be null. DFP_VOLUME_CANNOT_BE_NULL The billed from is DFP, but the DFP volume cannot be null. MANUAL_VOLUME_CANNOT_BE_NULL The billed from is manual, but the manual volume cannot be null. THIRD_PARTY_VOLUME_CANNOT_BE_NULL The billed from is third-party, but the third-party volume cannot be null. DUPLICATE_LINE_ITEM_AND_CREATIVE Duplicate tuples of (line item ID, creative ID). CANNOT_RECONCILE_LINE_ITEM_CREATIVE Cannot reconcile the ReconciliationReportRow as the line item ID and the creative ID association is invalid. LINE_ITEM_DAYS_MISMATCH Third-party days delivered and manual days delivered cannot differ for rows with same line item ID when line item cost type is CPD. LINE_ITEM_BILL_OFF_OF_MISMATCH ReconciliationReportRow.billFrom field cannot differ for rows with same line item id when line item cost type is CPD. CANNOT_MODIFY_RECONCILED_ORDER The order of the modifying rows in under reconciled status. The row couldn't be changed. CANNOT_MODIFY_ACROSS_MULTIPLE_RECONCILIATION_REPORTS Can not modify across multiple reconciliation reports. CANNOT_QUERY_ACROSS_MULTIPLE_RECONCILIATION_REPORTS Can not query across multiple reconciliation reports. CANNOT_UPDATE_VOLUME_WHEN_BILLABLE_REVENUE_OVERRIDDEN Cannot update reconciled volume when a billable revenue override is set. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
ReconciliationImportError	The API errors for reconciliation CSV import. Enumerations MISSING_EDITABLE_COLUMN The imported CSV missing some editable and essential columns. INCONSISTENT_IMPORT_COLUMNS The imported CSV columns count doesn't equal with defined columns count. COLUMN_CONVERSION_TYPE_ERROR The imported CSV column value cannot be converted to defined entity type. INCONSISTENT_COLUMNS_COUNT The imported CSV column values count are less or more than field headers count. IMPORT_INTERNAL_ERROR The imported CSV cause an internal error which is out of expectation. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
RequiredCollectionError	A list of all errors to be used for validating sizes of collections. Enumerations REQUIRED A required collection is missing. TOO_LARGE Collection size is too large. TOO_SMALL Collection size is too small. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
RequiredError	Errors due to missing required field. Enumerations REQUIRED Missing required field.
ServerError	Errors related to the server. Enumerations SERVER_ERROR Indicates that an unexpected error occured. SERVER_BUSY Indicates that the server is currently experiencing a high load. Please wait and try your request again. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
StatementError	An error that occurs while parsing Statement objects. Enumerations VARIABLE_NOT_BOUND_TO_VALUE A bind variable has not been bound to a value. UNKNOWN The value returned if the actual value is not exposed by the requested API version.
StringFormatError	A list of error code for reporting invalid content of input strings. Enumerations UNKNOWN ILLEGAL_CHARS The input string value contains disallowed characters. INVALID_FORMAT The input string value is invalid for the associated field.
StringLengthError	Errors for Strings which do not meet given length constraints. Enumerations TOO_LONG TOO_SHORT UNKNOWN The value returned if the actual value is not exposed by the requested API version.