Rob
Rob
TTwenty
Created by Rob on 9/19/2024 in #❓︱help
New Note Errors
No description
7 replies
TTwenty
Created by Rob on 7/3/2024 in #❓︱help
REST API: How to get multi select data
HI Twenty team! When using the REST API, I can sucesfully use find many companies to get information about companies. It contains many useful details. But, it does not return information about multi select fields. Is this intentional missing and there is another way for me to retrive this information? Or is it an upcoming feature or bug? Appreciate the great product and your help, Rob
14 replies
TTwenty
Created by Rob on 6/25/2024 in #❓︱help
Unable to link to google mail/calendar after upgrading from v0.20.0 to v0.20.2
Hi Twenty team, congrats on the new minor release, it's looking great! After upgrading I have experienced one bug. I am no longer able to connect to google accounts to pull in my mail and calendar. This worked flawlessly before the upgrade. Now when I click "Connect with Google" I am taken to a google page to choose my account, i select my account and hit continue, then I approve the permissions and hit allow. At this stage I would usually be taken back to the twenty crm page, but instead I am receiving a 500 error and get the following error in my logs...
query failed: SELECT "calendarChannel"."handle" AS "calendarChannel_handle", "calendarChannel"."connectedAccountId" AS "calendarChannel_connectedAccountId", "calendarChannel"."syncStatus" AS "calendarChannel_syncStatus", "calendarChannel"."syncStage" AS "calendarChannel_syncStage", "calendarChannel"."visibility" AS "calendarChannel_visibility", "calendarChannel"."isContactAutoCreationEnabled" AS "calendarChannel_isContactAutoCreationEnabled", "calendarChannel"."isSyncEnabled" AS "calendarChannel_isSyncEnabled", "calendarChannel"."syncCursor" AS "calendarChannel_syncCursor", "calendarChannel"."syncStageStartedAt" AS "calendarChannel_syncStageStartedAt", "calendarChannel"."throttleFailureCount" AS "calendarChannel_throttleFailureCount", "calendarChannel"."id" AS "calendarChannel_id", "calendarChannel"."createdAt" AS "calendarChannel_createdAt", "calendarChannel"."updatedAt" AS "calendarChannel_updatedAt" FROM "workspace_6irr16qioalagnvc5ffeneuhx"."calendarChannel" "calendarChannel" WHERE "calendarChannel"."id" IN ($1) -- PARAMETERS: ["df63f93d-2a2f-4482-9424-67156dc53337"]
error: error: column calendarChannel.syncStatus does not exist
query failed: SELECT "calendarChannel"."handle" AS "calendarChannel_handle", "calendarChannel"."connectedAccountId" AS "calendarChannel_connectedAccountId", "calendarChannel"."syncStatus" AS "calendarChannel_syncStatus", "calendarChannel"."syncStage" AS "calendarChannel_syncStage", "calendarChannel"."visibility" AS "calendarChannel_visibility", "calendarChannel"."isContactAutoCreationEnabled" AS "calendarChannel_isContactAutoCreationEnabled", "calendarChannel"."isSyncEnabled" AS "calendarChannel_isSyncEnabled", "calendarChannel"."syncCursor" AS "calendarChannel_syncCursor", "calendarChannel"."syncStageStartedAt" AS "calendarChannel_syncStageStartedAt", "calendarChannel"."throttleFailureCount" AS "calendarChannel_throttleFailureCount", "calendarChannel"."id" AS "calendarChannel_id", "calendarChannel"."createdAt" AS "calendarChannel_createdAt", "calendarChannel"."updatedAt" AS "calendarChannel_updatedAt" FROM "workspace_6irr16qioalagnvc5ffeneuhx"."calendarChannel" "calendarChannel" WHERE "calendarChannel"."id" IN ($1) -- PARAMETERS: ["df63f93d-2a2f-4482-9424-67156dc53337"]
error: error: column calendarChannel.syncStatus does not exist
Can you please assist me to fix this error and enable google sync again? Thanks!!!
12 replies
TTwenty
Created by Rob on 6/14/2024 in #❓︱help
Upgrading from v0.12 to v0.20
Hi Twenty team, congratulations on the new release! I am trying to upgrade my self hosted docker compose instance and have ran in to some errors. Could you please let me know if these are critical or not? I am migrating from v0.12.2 1. I upgraded my twenty and twenty-postgres images to use v0.20.0. They built and executed without issue. 2. I restored my database back to the new postgres image database. 3. I launched the twenty docker image and it automatically ran a database setup and migrations. The last message was "Successfuly migrated DB!" I followed instructions from: https://discord.com/channels/1130383047699738754/1130383048173682821/1250864881561894994 and ran 3. docker exec -it twenty_1 yarn database:migrate:prod This returned "No migrations are pending" 4. docker exec -it twenty_1 yarn command:prod workspace:sync-metadata -w 6e278d07-a88a-45d3-86c9-daea30a9b0e5 -f through the following warning (complete warning attached as txt)
[Nest] 224 - 06/14/2024, 4:13:14 AM WARN [SyncWorkspaceMetadataCommand] Workspace health check failed with error, but sync has been forced.
[Nest] 224 - 06/14/2024, 4:13:14 AM WARN [SyncWorkspaceMetadataCommand] EntityNotFoundError: Could not find any entity of type "DataSourceEntity" matching:
[Nest] 224 - 06/14/2024, 4:13:14 AM WARN [SyncWorkspaceMetadataCommand] Workspace health check failed with error, but sync has been forced.
[Nest] 224 - 06/14/2024, 4:13:14 AM WARN [SyncWorkspaceMetadataCommand] EntityNotFoundError: Could not find any entity of type "DataSourceEntity" matching:
14 replies
TTwenty
Created by Rob on 6/11/2024 in #❓︱help
REST API last_cursor usage
Hi Twenty Team, Thanks for the wonderful software. I have been interacting with the system using the REST API and it has been a huge productivty boost, thanks! However, I can not seem to figure out how to use the last_cursor variable. For example, when calling Find Many companies via https://{url}.com/rest/companies what should be passed in to the last_cursor variable? It says that it should be a string, I have tried passing in the last id from the previous call, and have tried passing in a a number or name of the last company. Can you provide some guidance to push me in the right direction to figure out how this works? My apologies if this is obvious for a developer.
18 replies
TTwenty
Created by Rob on 6/7/2024 in #❓︱help
Errors thrown when adding fields
No description
14 replies
TTwenty
Created by Rob on 5/28/2024 in #❓︱help
Programatic way to create a note for a company using REST?
Hi Twenty team 👋 Loving the extensibility of twenty! I've had great luck using the api to tidy up my CRM, see for example https://discord.com/channels/1130383047699738754/1244820584723120242/1244899581829845082 I am now trying to create a note via the rest api for a company, but I can't wrap my head around the playground docs. Assuming I have already obtained the company id that i need, e.g. company_id = 1983887e-1c8d-4cc2-a0b4-a747890d182d Do I use https://docs.twenty.com/rest-api/core#/operations/createOneActivity to make a note? Is there a minimal example somewhere of how to create a note via the api? Thanks again!
18 replies
TTwenty
Created by Rob on 5/28/2024 in #❓︱help
Converting text fields to links
Hi Twenty Team, I am loving the new links fields!!! I'd love to convert some of my existing text fields to link fields, is this possible? I have tried to do it via the webui, but can't see a way to change the type. Is there a command I can run via cli to change a field type? Or would you recommend I write a REST API script that does something like... 1. Via webui, change the name of the text field to indicate it's being decommisoned. E.g.change crunchbase to cruunchbase_text This didn't work, renaming fields seems to be a bad idea. 2. Via webui, create a new link field with the correct name. E.g. create a field called crunchbase 3. Via a script, get each company with a non empty crunchbase field, copy that text to a temporary location scratch1 field, and empty the crunchbase field 4. manually delete the crunchbase field via the web ui. Create a new crunchbase field that is of type links 5. Via a script, get each company with a non empty scratch1 field, copy that text to the new crunchbase field, and empty the scratch1 field Loving the new features!! Thanks for your help in this transition
7 replies
TTwenty
Created by Rob on 5/27/2024 in #❓︱help
Getting logged regularly (~15 mins)
Hi Twenty team, Thanks for the wonderful software product. I am using google authentication. I am able to log in via google auth and also authenticate with mail and calendar sync etc. However, I am logged out reguarly. About every 15 mins. My docker compose currently includes:
LOGIN_TOKEN_EXPIRES_IN: 90d
ACCESS_TOKEN_EXPIRES_IN: 30m
LOGIN_TOKEN_EXPIRES_IN: 90d
ACCESS_TOKEN_EXPIRES_IN: 30m
and i logged in to the docker image and ran env and it showed...
/app/packages/twenty-server $ env
CACHE_STORAGE_TYPE=redis
CACHE_STORAGE_TTL=3600
REDIS_PORT=6379
ENABLE_DB_MIGRATIONS=true
NODE_VERSION=18.17.1
SENTRY_RELEASE=
HOSTNAME=dc289588ed46
YARN_VERSION=1.22.19
REACT_APP_SERVER_BASE_URL=
SHLVL=1
PORT=3854
FRONT_BASE_URL=https://{redacted}
CALENDAR_PROVIDER_GMAIL_ENABLED=true
HOME=/home/node
ACCESS_TOKEN_SECRET={redacted}
LOGIN_TOKEN_SECRET={redacted}
PG_DATABASE_URL={redacted}
CALENDAR_PROVIDER_GOOGLE_ENABLED=true
AUTH_GOOGLE_CLIENT_ID={redacted}
AUTH_GOOGLE_CLIENT_SECRET={redacted}
AUTH_GOOGLE_ENABLED=true
STORAGE_TYPE=s3
STORAGE_S3_NAME={redacted}
TERM=xterm
FILE_TOKEN_SECRET={redacted}
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REFRESH_TOKEN_SECRET={redacted}
SIGN_IN_PREFILLED=false
STORAGE_S3_REGION={redacted}
AWS_ACCESS_KEY_ID={redacted}
AWS_SECRET_ACCESS_KEY={redacted}
AUTH_GOOGLE_CALLBACK_URL=https://{redacted}/auth/google/redirect
SERVER_URL=https://{redacted}
ACCESS_TOKEN_EXPIRES_IN=30m
MESSAGING_PROVIDER_GMAIL_ENABLED=true
LOGIN_TOKEN_EXPIRES_IN=90d
REDIS_HOST=192.168.1.4
PWD=/app/packages/twenty-server
IS_SIGN_UP_DISABLED=false
AUTH_GOOGLE_APIS_CALLBACK_URL=https://{redacted}/auth/google-apis/get-access-token
MESSAGE_QUEUE_TYPE=bull-mq
/app/packages/twenty-server $
/app/packages/twenty-server $ env
CACHE_STORAGE_TYPE=redis
CACHE_STORAGE_TTL=3600
REDIS_PORT=6379
ENABLE_DB_MIGRATIONS=true
NODE_VERSION=18.17.1
SENTRY_RELEASE=
HOSTNAME=dc289588ed46
YARN_VERSION=1.22.19
REACT_APP_SERVER_BASE_URL=
SHLVL=1
PORT=3854
FRONT_BASE_URL=https://{redacted}
CALENDAR_PROVIDER_GMAIL_ENABLED=true
HOME=/home/node
ACCESS_TOKEN_SECRET={redacted}
LOGIN_TOKEN_SECRET={redacted}
PG_DATABASE_URL={redacted}
CALENDAR_PROVIDER_GOOGLE_ENABLED=true
AUTH_GOOGLE_CLIENT_ID={redacted}
AUTH_GOOGLE_CLIENT_SECRET={redacted}
AUTH_GOOGLE_ENABLED=true
STORAGE_TYPE=s3
STORAGE_S3_NAME={redacted}
TERM=xterm
FILE_TOKEN_SECRET={redacted}
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REFRESH_TOKEN_SECRET={redacted}
SIGN_IN_PREFILLED=false
STORAGE_S3_REGION={redacted}
AWS_ACCESS_KEY_ID={redacted}
AWS_SECRET_ACCESS_KEY={redacted}
AUTH_GOOGLE_CALLBACK_URL=https://{redacted}/auth/google/redirect
SERVER_URL=https://{redacted}
ACCESS_TOKEN_EXPIRES_IN=30m
MESSAGING_PROVIDER_GMAIL_ENABLED=true
LOGIN_TOKEN_EXPIRES_IN=90d
REDIS_HOST=192.168.1.4
PWD=/app/packages/twenty-server
IS_SIGN_UP_DISABLED=false
AUTH_GOOGLE_APIS_CALLBACK_URL=https://{redacted}/auth/google-apis/get-access-token
MESSAGE_QUEUE_TYPE=bull-mq
/app/packages/twenty-server $
Do you have any suggestions why i might be constantly logged out? Could it be an issue with my google console settings? or do you think its an issue with my twenty setup? Thanks in advance!
4 replies
TTwenty
Created by Rob on 5/24/2024 in #❓︱help
Gmail error in logs. "Auth already failed, a new refresh token is needed"
Hi Twenty team, thanks for the great software. It is really amazing and improving every day! I have two workspaces. In workspace 9f7ecf08-68ee-4c75-83b8-6e5716601558 I have one user. That user had linked to the google mail/calendar. But then I removed the connection via the WebUI. However, i still see the server trying to connect and pull mail and failing (see logs below). What is the best way for me to fix the errors in the log? I would like to reconnect that user to the google account, but would like to fix this error before I do. Thanks
4 replies
TTwenty
Created by Rob on 5/16/2024 in #❓︱help
Error during userFindManyRecords for .... Response not successful: received status code 400
No description
117 replies
TTwenty
Created by Rob on 5/4/2024 in #❓︱help
Calendar Functionality
No description
42 replies