Anypoint™ Connector for Google Ad Manager

Click the Global Elements tab at the base of the canvas, then click Create.

In the Choose Global Type menu, use the filter to locate and select Google Ad Manager: OAuth 2.0, then click OK.

Configure the parameters according to the table below.

Click the Global Elements tab at the base of the canvas, then click Create.

In the Choose Global Type menu, use the filter to locate and select Google Ad Manager: Service Account, then click OK.

Configure the parameters according to the table below.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

Add a Dataweave transformer after HTTP endpoint to create a new Google Company to pass on to the connector. Do the mapping from a JSON object to a Google Company object to assign the values.

    <configuration doc:name="Configuration">
        <expression-language>
            <global-functions>
              def stringToCompanyType(enumString){
    		return com.google.api.ads.admanager.axis.v201902.CompanyType.fromString(enumString.toUpperCase())
          	}
    	     </global-functions>
         </expression-language>
    </configuration>

Add another Dataweave transformer after the Google Ad Manager endpoint to map an object of List<Long> returned by the Google Ad Manager to JSON and extract the new company ID.

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a POST request to: http://localhost:8081/createCompany with a suitable body:

    {
      "Companies":
      [
        {
          "companyName": "demoCompany",
          "companyAddress": "12, John Doe Street, Birkirkara BKR1234",
          "companyEmail": "hello@democompany.com",
          "companyType": "Agency"
        }
      ]
    }

The Mule application will perform the operation and add the Company record to Google Ad Manager. An ID should be returned in JSON format.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

In the Query Params field, select Create Object manually. Click the button …​ and in the popup window that opens select the + sign to create a new object. Configure the new object as follows:

Add an Object to JSON transformer after the Google Ad Manager connector endpoint.

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a GET request to: http://localhost:8081/getCompany/1234. Here 1234 refers to the ID of the company you are trying to retrieve.

The Mule application will perform the operation and return JSON data containing information about the company requested.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Add a Dataweave transformer after HTTP endpoint to create a new Google Company to pass on to the connector. Do the mapping from a JSON object to a Google Company object to assign the values.

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

Add an Object to JSON transformer after the Google Ad Manager connector endpoint to transform the Google Company object into JSON data.

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a PUT request to: http://localhost:8081/updateCompany with a suitable body:

    {
      "Companies":
      [
        {
        "companyId": "12345",
        "companyEmail" : "updatedcompanyemail@mycompany.com",
        "companyName": "updatedCompany",
        "companyAddress": "60, John Doe Street, Birkirkara BKR1234"
        }
      ]
    }

The Mule application will perform the operation and return the ID of the update company record.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Add a Dataweave transformer after HTTP endpoint to create a new Report object to pass on to the connector.

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

Add an Object to JSON transformer after the Google Ad Manager connector endpoint to transform the Report object into JSON data.

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a POST request to: http://localhost:8081/createReport with a suitable body:

    {
      "Report": {
        "dimensions": "LINE_ITEM_ID,MONTH_AND_YEAR",
        "columns": "AD_SERVER_IMPRESSIONS",
        "dimensionAttributes": null,
        "startDate": "2017-01-01",
        "endDate": "2019-01-31"
      }
    }

The Mule application will perform the operation and return the contents of the created report.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Add a Dataweave transformer to map the data into a Report object. For the purpose of this example, the data for the report we wish to create has been hardcoded.

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

Add another Google Ad Manager connector endpoint and configure it with the operations to download a report:

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a GET request to: http://localhost:8081/createDownload.

The Mule application will perform the operation and the created report should be displayed in XML format.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows:

    <configuration doc:name="Configuration">
        <expression-language>
            <global-functions>
              def stringToExportFormat(enumString){
    		return com.google.api.ads.admanager.axis.v201902.ExportFormat.fromString(enumString.toUpperCase())
          	}
    	     </global-functions>
         </expression-language>
    </configuration>

Add a Dataweave transformer after the Google Ad Manager connector endpoint and modify it as follows:

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a GET request to: http://localhost:8081/reportUrl/1234. Here 1234 refers to the ID of the report you are trying to retrieve.

The Mule application will perform the operation and return download URL for the requested report.

Drag an HTTP Endpoint into a new flow. Configure a new HTTP Listener Configuration on Port 8081. In the properties view of the HTTP Endpoint configure the HTTP endpoint as follows:

Drag a Google Ad Manager connector endpoint into the same flow. Select it to open the properties editor console. Next to Connector Configuration click the + sign to add a new connection configuration and add your credentials. Set the rest of the properties as follows: (For the purpose of demonstrating the operation, the query values have been hardcoded)

In the Query Params field, select Create Object Manually and click on …​. In the popup window that appears, click the + to configure a new Object. Create a new object as follows:

Add an Object to JSON transformer after the Google Ad Manager connector endpoint.

Save the project and then run it as a Mule Application (right-click project name, then select Run As > Mule Application).

Make a GET request to: http://localhost:8081/pql/1234. Here 1234 refers to the ID of the report you are trying to retrieve.

The Mule application will perform the operation and return the results of the query.