[Bug]-[440]:Airtable API key/ Bearer token field does not appear on the datasource

[prapullac]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

When the user tries to add the token or key after the selection it is observed that the field does not appear

Steps To Reproduce

1) Navigate to datasource 2) select the Airtable 3) Select API key/ Bearer token and observe that field to add the key is not displayed to the user

Public Sample App

release

Version

cloud

Front conversations

[felixsuarez0727]

Inputs are working fine for me. I'm unable to reproduce.

This bug seems to be intermittent, I'm still trying to figure out the source cause.

[subrata71]

@felixsuarez0727 This is the server response I am getting when clicking on creating new Airtable datasource

Request

Request URL: https://release.app.appsmith.com/api/v1/datasources Request Method: POST Status Code: 201 Created

Response

{
    "responseMeta": {
        "status": 201,
        "success": true
    },
    "data": {
        "id": "62d5a0c13df1fa12f087f0d3",
        "userPermissions": [
            "execute:datasources",
            "manage:datasources",
            "read:datasources"
        ],
        "gitSyncId": "629498fe0b092f4f690a5d4e_62d5a0c03df1fa12f087f0d2",
        "name": "Untitled Datasource 8",
        "pluginId": "61531b1b9370f312a0394f16",
        "pluginName": "Airtable",
        "workspaceId": "629498fe0b092f4f690a5d4e",
        "invalids": [
            "No datasource configuration found. Please configure it and try again."
        ],
        "messages": [],
        "isConfigured": false,
        "isValid": false,
        "new": false
    }
}

Is it an expected response?

[felixsuarez0727]

This was taken from Prod, the response does seem to be the right one.

{
    "responseMeta": {
        "status": 201,
        "success": true
    },
    "data": {
        "id": "62d976efe1c2ed505a05897f",
        "userPermissions": ["execute:datasources", "manage:datasources", "read:datasources"],
        "gitSyncId": "62d76be5b06ce90d91dbe9de_62d976efe1c2ed505a05897e",
        "name": "Untitled Datasource 4",
        "pluginId": "61dbfd4b6bd5757f166ccc76",
        "pluginName": "Airtable",
        "workspaceId": "62d76be5b06ce90d91dbe9de",
        "invalids": ["No datasource configuration found. Please configure it and try again."],
        "messages": [],
        "isConfigured": false,
        "isValid": false,
        "new": false
    }
}

[felixsuarez0727]

Since we are using the Release Importer (tool that copies integration config from Prod to Release), I would expect the pluginId to be the same, yet it is not. (I will be looking into this)

Another behavior that I have noticed is that this seems to be intermittent. I couldn't reproduce it for the last couple of days, yet @AmanAgarwal041 and @prapullac were able to provide picture. Nonetheless, yesterday @AmanAgarwal041 was unable to reproduce it on the same organization he was able to reproduce it a day ago.

[prapullac]

@felixsuarez0727 @AmanAgarwal041: I am still seeing this on the release regression. However, we also observe that fields do not appear on Twillio command selection.

[felixsuarez0727]

The following tests were performed but not able to reproduce the errors.

Steps to Reproduce

1. Login to release.app.appsmith.com
2. Create a new Twilio datasource
3. Verify if the authentication inputs appear.
4. Verify the inputs of the actions

This happens on the following environments:

• Firefox: (64 bit) on Ubuntu 20.04.3
• Chrome: (64-bit) on Windows 10

Operating System	Browser	Number of Tests	Inputs Work
Ubuntu	Chrome	10	Yes
Ubuntu	Firefox	10	Yes
Windows	Chrome	10	Yes
Windows	Firefox	10	Yes
Windows	Microsoft Edge	10	Yes
Windows	Opera	10	Yes

https://images.zenhubusercontent.com/275993885/e136f136-ec79-4461-a09b-97529d69b121/video1.mp4

https://images.zenhubusercontent.com/275993885/12dd34fc-c195-4a1b-a460-215ad30a5fdb/video2.mp4

Note:

• At the time of testing everything was working fine. We also installed the browser from scratch on a computer that did not have it, and it worked, we were unable to reproduce the error with this tests.

[felixsuarez0727]

I created this table to have a register of the moments that Twilio and Airtable inputs work in Release, maybe we can see a pattern. Note that time zone is UTC.

Steps to Reproduce

1. Login to release.app.appsmith.com
2. Create a new Twilio datasource
3. Verify if the authentication inputs appear.
4. Verify the inputs of the actions

Date	Worked	URL
2022-27-07 16:15:00	No	release.app.appsmith.com / our instance
2022-27-07 18:44:00	Yes	release.app.appsmith.com / our instance
2022-28-07 16:20:00	Yes	release.app.appsmith.com / our instance
2022-28-07 21:00:00	Yes	release.app.appsmith.com / our instance
2022-29-07 19:00:00	Yes	release.app.appsmith.com / our instance
2022-29-07 21:15:00	Yes	release.app.appsmith.com / our instance
2022-30-07 8:00:00	No	release.app.appsmith.com / our instance
2022-30-07 12:18:00	Yes	release.app.appsmith.com / our instance
2022-31-07 8:00:00	Yes	release.app.appsmith.com / our instance
2022-31-07 14:30:00	Yes	release.app.appsmith.com / our instance

[felixsuarez0727]

I also tested on Release_aug1 of the prapulla branch. And at the time of 2022-01-08 20:00:00 (UTC) the inputs worked fine.

[felixsuarez0727]

To check with Sumit.

[felixsuarez0727]

Sumit is currently looking at this issue.

[sumitsum]

Airtable usage in 6m: 331 % of users impacted: 50 %

Stats

Stat	Values
Reach	165
Effort (months)	0.75

[praneetloke]

I am experiencing this issue right now. I've tried to restart AppSmith to no luck. It also seems that the Queries against such a datasource also lose the ability to display any of the inputs. Strangely, I can see the input field for the "Bearer Token" authentication mechanism. Is there anything else I can do to help diagnose this issue?

EDIT: I am on the latest release version, which is 1.9.3.1 at the time of this writing.

[GreenFlux]

another user on Discord is facing this issue: https://discord.com/channels/725602949748752515/1064204306951176302

[btsgh]

Reproduced this again on Release Regression on 1.9.5 [24th jan 2023]

[praneetloke]

Weirdly, though, after my AppSmith instance restarted automatically when it updated to 1.9.4, the Airtable datasource config form worked perfectly and so did configuring Airtable queries. I haven't checked if it is still working with 1.9.5, though. I can check it later and if it has reverted to not working again for me, I am happy to provide diagnostic info if you tell me what you would need.

[Irongade]

After discussing with Nidhi, we confirmed that a backend engineer would be better poised to fix this issue as they'll need to work on the Java code that returns these configs. This is because Airtable is a saas plugin and there is no explicit form that is kept on the server side for the Airtable plugin that I can manually fix.

[sumitsum]

Removed the release blocker tag since the issue still looks flaky - i.e same behaviour as before.

[btsgh]

Have pinged @sumitsum to understand the steps to setup the cloud services locally. Waiting for a response on this. Unable to proceed to setup env given in step 1 in the PR

[btsgh]

This has been tested as per the steps mentioned in the fix and it is working fine. Hence moving the issue to Ready to Merge. [Have run the query on postman around 100 times.. and did not find anything amiss]