Questions tagged with Amazon AppFlow
Content language: English
Sort by most recent
How can I schedule AppFlow data transfers?
I need to transfer data from Google Analytics to Redshift cluster regularly. Is there a way to automate this process and schedule data transfers with AppFlow? If so, can anybody provide step-by-step instructions on how to set up a schedule?
Hi, can appflow be used to transfer data from Redshift to S3? Is there any other option which is better than this?
Hi Team,
I faced an issue with Appflow to snowflake connection issue. We have raised an issue in the snowflake support and they are also facing the same and couldn't identify the JDBC version. Could you please share us with the **JDBC trace log** and the **JDBC driver version** used from that log?
Thanks,
Nivya
We set up a flow syncing Google Analytics 4 metrics Metric:active1DayUsers, Metric:active7DayUsers, Metric:active28DayUsers by dimension Dimension:country.
We have no filters.
This flow succeeds on demand, but fails on schedule with this message:
```
The request failed because the service Source Google Analytics 4 returned the following error: Details: The field that you specified as a filter, active1DayUsers, is not supported by the data object that you assigned to this flow. Specify a valid field and try again., ErrorCode: InvalidArgument.
```
Any idea how I can fix this?
Created an App flow to Load Data from S3 Bucket to salesforce Instance.
While mapping Standard Look Up fields AppFlow is using wrong syntax for field Mapping due to this I am getting Error while loading data .
Example : During Contact Upsert while relating contact record with Account using Account External ID, Appflow is using Syntax as “AccountID.AccountExternalField”, but it should be “Account.AccountExteranlField”.
Error Message :
[{"error":"[{\"message\":\"Cannot deserialize instance of reference from START_OBJECT value { or request may be missing a required field at [line:1, column:149]\",\"errorCode\":\"JSON_PARSER_ERROR\"}]
I'm able to transfer public channel messages from Slack with appflow, but not direct messages. Is this possible?
Hello,
I want to extract data from my SAP SuccessFactors instance and load them on AWS S3. Is it possible to leverage AWS AppFlow for this integration? I saw some examples using SAP ECC, BW, BW/4HANA and S/4HANA but not with SAP SuccessFactors.
Thanks for the support
While configuring the Flow for one of the HubSpot entities in the AppFlow, I have noticed that if I try to configure the Schedule Trigger, the incremental load option is grayed out and there is no way to enable it. I have a feeling that it did work few weeks back when I was doing a PoC.
Thank you for your help
Hi,
I have started using the AppFlow HubSpot connector yesterday and trying to ingest some of the customer's data.
First I have bumped into [this ](https://repost.aws/questions/QUEK41q2c4TT6Qtky6j0J7Vg/app-flow-hubspot-connection-not-updating-the-token) issue.
Then I have moved on and tried to ingest other objects from the [list](https://docs.aws.amazon.com/appflow/latest/userguide/connectors-hubspot.html).
When I tried to ingest Campaign and Email_Event, I got the 403 again and after checking the logs on the HubSpot DevAccount, I saw this:
```
{"status":"error","message":"This app hasn't been granted all required scopes to make this call. Read more about required scopes here: https://developers.hubspot.com/scopes.","correlationId":"924b2950-d7ae-461b-916b-c4735fdbbcac","errors":[{"message":"One or more of the following scopes are required.","context":{"requiredScopes":["content"]}}],"links":{"scopes":"https://developers.hubspot.com/scopes"},"category":"MISSING_SCOPES"}
```
Needless to say that when I add mentioned scope to the HubSpot App and trying to re-connect the AppFlow HubSpot connector - it breaks.
Can I please have some with this.
For the Owner object from HubSpot v3 API ingestion worked ok.
Hi,
I have setup the hubspot connection in the AppFlow with all required scopes configured as per [https://docs.aws.amazon.com/appflow/latest/userguide/connectors-hubspot.html](link). After configuring the flow and running it, I have noticed that after some time the ingestion fails and I am getting 401 from HubSpot. The logs on the HubSpot show that the token timed out.
To fix it I need to edit connection and re-submit userid and the secret.
AppFlow establishes the initial connection with ClientId and Secret however after the first token expired, AppFlow is not renewing it.
Hi
Need help in creating a authentication header when using AWS endpoints directly instead of AWS boto3 SDK.
Using the same access ID and KEY, boto3 code is working, we have to use AWS endpoint directly for some specific reason.
This is just a example, ignore content-type and accept. data=data is data what we are passing, that is formatted correctly.
Any help will be appreciated.
Error message - {'message': 'Missing Authentication Token'}
```
headers = {
"aws_access_key_id" : "---------------------------",
"aws_secret_access_key" : "----------------------"
"Content-Type" : "application/x-www-form-urlencoded",
"Accept" : "application/json"
}
response = requests.post("https://appflow.us-east-2.amazonaws.com/update-flow", data=data, headers=headers, verify=True)
print(response.json())
```
"error while communicating with connector client error the request to sap failed with status code 400 connection time out"
Hi, when trying to make a connection between SAP & Appflow with SAP OData connector, we are getting the above error message, please guide on resolution