Loading shopify data to bigquery

[prateekcholkar]

I want to load orders data from shopify to bigquery. Below is my application integration

1. Fetch Shopify Data is able to gather the orders data

2. Data Mapping: I am converting json into array.

3. For each loop calls the sub integration

Sub Integration:

1. Issue / Error: Sub Integration fails with below error

{
“message”: “Required parameter Connector input payload is not present.”,
“code”: 500
}

Order Data from the parent integration service

Error message on parent integration:

‘Required parameter Connector input payload is not present.’ eventMessages without params: ‘[name: “CreateOrderSubIntegration” event_info_id: “9d2dfd6f-03e4-4fb4-bcbd-3500ff37a9f8” trigger_id: “api_trigger/CreateOrderSubIntegration_API_1” client_id: “79307376312” execution_state: FAILED cloud_logging_details { } event_bus_status: ACTIVE snapshot_number: 3 workflow_origin: UI ]’ error/code: ‘common_error_code: INVALID_PARAMETER’

[vsy]

Thank you for asking this question. Have you mapped the variables(“Map to additional sub-integration input”) from the parent integration(the one which contains For-Loop) to the child integration(containing BQ connection) in your For-Each Loop task ?

[prateekcholkar]

Hello @vsy

Below is the setup, I have. Do you think I am missing something here. Please confirm

Task_1_connectorInputPayload - It is the input for subintegration