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 Config, then click OK.

Configure the parameters according to the following table:

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 Config, then click OK.

Configure the parameters according to the following table:

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Select the Google Ad Manager from the Mule Pallette and then drag the Create endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

To create a new Google Ad Manager Company object, add a Transform Message transformer after HTTP endpoint. Map the JSON payload as follows:

    %dw 2.0
    import java!com::google::api::ads::admanager::axis::v201902::CompanyType

    fun stringToCompanyType(enumString) =
      CompanyType::fromString(upper(enumString))

Add another Transform Message transformer after the Google Ad Manager endpoint to map the payload object (e.g. List<Long> for Companies) to a JSON object 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 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 add the respective Company record to Google Ad Manager and return the created object ID in JSON format.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Select the Google Ad Manager from the Mule Pallette and then drag the Get endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

In the Query Params field, select Edit inline. Click the + sign to create a new object and configure it as follows:

Add an Transform Message transformer after the Google Ad Manager connector endpoint to convert to payload to a JSON object (output application/json).

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 retrieve the respective company and its information as JSON.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Add a Transform Message transformer after the HTTP endpoint to create a new Google Ad Manager Company to pass to the connector as payload. In the Transform Message properties view, map a JSON object to a Company object and assign the respective values.

Select the Google Ad Manager from the Mule Pallette and then drag the Update endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

Add another Transform Message transformer after the Google Ad Manager connector endpoint to transform the Google Company object into JSON object.

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 update the respective company record and return its ID.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Add a Transform Message transformer after HTTP endpoint to create a new Report object to pass on to the connector as payload.

Select the Google Ad Manager from the Mule Pallette and then drag the Create Report endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

Add another Transfrom Message 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 create the report and return its contents.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Add a Transform Message transformer to map the data to a Java object.

Select the Google Ad Manager from the Mule Pallette and then drag the Create Report endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

From the Mule Pallette drag the Download Report endpoint and configure 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/createDownload.

The Mule application will create the report and provide a link to download it in XML format.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Select the Google Ad Manager from the Mule Pallette and then drag the Get Report Download Url endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

    %dw 2.0
    import java!com::google::api::ads::admanager::axis::v201902::ExportFormat

    fun stringToExportFormat(enumString) =
      ExportFormat::fromString(upper(enumString))

Add a Transform Message 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 return the download URL for the requested report.

Drag an HTTP Listener endpoint into a new flow. In the properties view of the HTTP Listener endpoint configure it as follows:

Select the Google Ad Manager from the Mule Pallette and then drag the Select PQL endpoint into the same flow. Select it to open its properties editor. Next to Connector Configuration click the + sign to add a new connection configuration or choose one from the list. Set the remaining properties as follows:

In the Query Params field, select Edit inline and click the + sign to configure a new parameter. Configure it follows:

Add an Transform Message transformer after the Google Ad Manager connector endpoint and configure it to convert the payload to a JSON object.

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 return the query results.