|
5365
|
Dimensions:
Width:
Height:
1812
1080
Video quality Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,66 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
01:21,33...
|
CleanShot X
|
CleanShot
|
NULL
|
5365
|
|
5366
|
Dimensions:
Width:
Height:
1812
1080
Video quality Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,66 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
03:36,22...
|
CleanShot X
|
CleanShot
|
NULL
|
5366
|
|
5367
|
Dimensions:
Width:
Height:
1812
1080
Video quality Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,66 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
05:45,93...
|
CleanShot X
|
CleanShot
|
NULL
|
5367
|
|
5368
|
Dimensions:
Width:
Height:
1812
1080
Video quality Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,66 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
06:09,43...
|
CleanShot X
|
CleanShot
|
NULL
|
5368
|
|
5369
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%...
|
CleanShot X
|
CleanShot
|
NULL
|
5369
|
|
5370
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%...
|
CleanShot X
|
CleanShot
|
NULL
|
5370
|
|
5371
|
Do you want to replace the existing video?
Replace Do you want to replace the existing video?
Replace Video
Save as New Video
Cancel
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com1819476:19 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
CleanShot X
|
|
NULL
|
5371
|
|
5372
|
Do you want to replace the existing video?
Replace Do you want to replace the existing video?
Replace Video
ActivityMoreCleanShot XJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves. Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...::: ADoS-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EU.A DEAL RISKS (EU1#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 187#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190Q Describe what you are looking forw releases9 22MessagesO Deplos( Files& BookmarksProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull rec1 Useroild• JY-2077ProblenDo Search :8 JiminnyL Now TaJ JIMINNYg For youinny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.• Search|spaces Jiminny (New)4100Video quality:Dimensions1812 x 1080 Oriaina)]Width. 1912Height:1080|Estimated file size: ~1.4 GB-1 UltraAudio:Don't changea Convert to mono• MuteChange volumeTrim OnivAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulGOWOOA100% s2•Thu 7 May 18:19:47+ CreateAsk RovoActive sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: @ueriesICODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7rageSync opportunitiesIND FAS...owner (user_id is..Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSIn OAlDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow ticorc to dolotaSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
CleanShot X
|
|
NULL
|
5372
|
|
5373
|
Do you want to replace the existing video?
Replace Do you want to replace the existing video?
Replace Video
Save as New Video
Cancel
ActivityMoreCleanShot XJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves. Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...::: ADoS-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EU.A DEAL RISKS (EU1#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 187#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190Q Describe what you are looking forw releases8 22MessagesO Deplos( Files& BookmarksProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull recU Useroil( JY-2071ProblenDo Search :8 JiminnyL Now Talg For youminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.J JIMINNY• Search|spaces Jiminny (NewGOWOOA100% s2•Thu 7 May 18:19:50+ CreateAsk RovoVideo quality:Dimensions1812 x 1080 (Original)Do you wisting vreplace theReplace VideoSave as New VideoCancellon't change• Convert to moncMuteChance volumeEstimated file size: ~1.4 GBAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn Noul• Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: @ueriesICODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesIND FAS...owner (user_id is..Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSIn OAlDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow ticorc to dolotaSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
CleanShot X
|
|
NULL
|
5373
|
|
5374
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5374
|
|
5375
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5375
|
|
5376
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5376
|
|
5377
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5377
|
|
5378
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5378
|
|
5379
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5379
|
|
5380
|
2
New
Ask Gemini
Gemini is available to answer que 2
New
Ask Gemini
Gemini is available to answer questions
about meeting discussions. It won't create a
recording or store caption data after the
meeting ends. The meeting host can turn it
off in settings.
Learn more
Don't show again
Stefka Stoyanova
Lukas Kovalik
5:36 PM
Lukas/Stefka 121
©
心
目
Analyze Image
Dimensions:
Width:
Height:
1812
1080
Video quality:
Ultra
Trim & Convert
Trim Only
Cancel
Estimated file size: ~1,4 GB
play/pause
Audio:
Convert to mono
Don't change
Mute
0%
Change volume
100%
200%
Converting Video...
stop progress...
|
CleanShot X
|
CleanShot
|
NULL
|
5380
|
|
5381
|
Video encoded successfully!
The final file size is Video encoded successfully!
The final file size is 1,55 GB (106% of the original).
Don't show again
OK
ActivityMoreCleanShot XJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...#: Aops-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EU.A DEAL RISKS (EU1#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 187#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190Q Describe what you are looking forw releases8 22MessagesO Deplo!( Files& BookmarksProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull recU Useroil( JY-2071ProblenDo Search :8 JiminnyL Now Talg For youminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.J JIMINNY• Search|spaces Jiminny (NewVideo encoded successfullv.The final ie sx orig i:a5) CB (106% ofDon t show adainVideo quality:Dimensions1812 x 1080 OriainaliEstimated file size: ~1.4 GBDon't change• Convert to moncMuteChance volumeAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulGOWOOA100% s2Thu 7 May 18:21:29+ CreateAsk Rovo• Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: QueriesCODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesIND FAS...owner (user_id is..Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSTn OAIDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow users to deleteSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
CleanShot X
|
|
NULL
|
5381
|
|
5382
|
Video encoded successfully!
The final file size is Video encoded successfully!
The final file size is 1,55 GB (106% of the original).
Don't show again
OK
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com18:21:506:21 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
CleanShot X
|
|
NULL
|
5382
|
|
5383
|
Video encoded successfully!
The final file size is Video encoded successfully!
The final file size is 1,55 GB (106% of the original).
Don't show again
OK
ActivityMoreCleanShot XJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...#: Aops-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EU.A DEAL RISKS (EU1#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 187#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190Q Describe what you are looking forw releases8 22MessagesO Deplos( Files& BookmarksProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull recU Useroil( JY-2071ProblenDo Search :8 JiminnyL Now Talg For youminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.J JIMINNY• Search|spaces Jiminny (NewVideo encoded successfullv.The final ie sx orig i:a5) CB (106% ofDon t show adainVideo quality:Dimensions1812 x 1080 OriainaliEstimated file size: ~1.4 GBDon't change• Convert to moncMuteChance volumeAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulGOWOOA100% s2Thu 7 May 18:22:00+ CreateAsk Rovo• Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: QueriesCODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesIND FAS...owner (user_id is..Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSIn OAlDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow users to deleteSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
CleanShot X
|
|
NULL
|
5383
|
|
5384
|
Video encoded successfully!
The final file size is Video encoded successfully!
The final file size is 1,55 GB (106% of the original).
Don't show again
OK
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com6:22 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
CleanShot X
|
|
NULL
|
5384
|
|
5385
|
Video encoded successfully!
The final file size is Video encoded successfully!
The final file size is 1,55 GB (106% of the original).
Don't show again
OK
ActivityMoreCleanShot XJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...#: Aops-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EU.A DEAL RISKS (EU1#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 187#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190Q Describe what you are looking forw releases8 22MessagesO Deplo!( Files& BookmarksProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull recU Useroil( JY-2071ProblenDo Search :8 JiminnyL Now Talg For youminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.J JIMINNY• Search|spaces Jiminny (NewVideo encoded successfullv.The final ie sx orig i:a5) CB (106% ofDon t show adainVideo quality:Dimensions1812 x 1080 OriainaliEstimated file size: ~1.4 GBDon't change• Convert to moncMuteChance volumeAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulGOWOOA100% s2Thu 7 May 18:22:31+ CreateAsk Rovo• Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: @ueriesICODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesIND FAS...owner (user_id is..Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSTn OAIDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow users to deleteSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
CleanShot X
|
|
NULL
|
5385
|
|
5386
|
Switch workspaces… (Jiminny Inc) Has new messages
Switch workspaces… (Jiminny Inc) Has new messages
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
1
Directories
jiminny-x-integration-app
platform-inner-team
ai-chapter
alerts
backend
bugs
confusion-clinic
curiosity_lab
engineering
general
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Stoyan Tanev
Stefka Stoyanova
Ves
Galya Dimitrova
Aneliya Angelova
Vasil Vasilev
James Graham
Nikolay Ivanov
Lukas Kovalik
you
Jira Cloud
Toast
Messages
Messages
Files
Files
Bookmarks
Bookmarks
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to first unread message (⌘J)
Mark as read (esc)
Jump to date
Today at 4:33:51 PM
4:33
New commits deployed to Prophet Prod-EU:
[74673da](
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
) - [JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502) (steliyan-g)
GitHub
APP
Today at 5:03:19 PM
5:03 PM
3 new commits
3 new commits
pushed to
master
master
by
mihailmihaylovjiminny
mihailmihaylovjiminny
beb8e387
beb8e387
- JY-20817: Fix deleting old tracks
8f177131
8f177131
- Merge branch 'master' into JY-20817-fix-deleting-old-tracks
[CREDIT_CARD]
- Merge pull request #12052 from jiminny/JY-20817-fix-deleting-old-tracks
jiminny/app
jiminny/app
|
Added by
GitHub
GitHub
CircleCI
APP
Today at 5:29:41 PM
5:29 PM
Deployment Successful! tada emoji
Deployment Successful!
Project
: app
When
: 05/07/2026 14:29:40
Tag
:
View Job
View Job
New
CircleCI
APP
Today at 6:18:57 PM
6:18 PM
New commits deployed to Prophet Prod-US:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 6:19:24 PM
6:19
New commits deployed to Prophet Prod-EU:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Channel releases
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com1822466:22 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
Slack
|
releases (Channel) - Jiminny Inc - 3 new items - S releases (Channel) - Jiminny Inc - 3 new items - Slack...
|
NULL
|
5386
|
|
5387
|
Switch workspaces… (Jiminny Inc) Has new messages
Switch workspaces… (Jiminny Inc) Has new messages
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
1
Directories
jiminny-x-integration-app
platform-inner-team
ai-chapter
alerts
backend
bugs
confusion-clinic
curiosity_lab
engineering
general
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Stoyan Tanev
Stefka Stoyanova
Ves
Galya Dimitrova
Aneliya Angelova
Vasil Vasilev
James Graham
Nikolay Ivanov
Lukas Kovalik
you
Jira Cloud
Toast
Messages
Messages
Files
Files
Bookmarks
Bookmarks
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to first unread message (⌘J)
Mark as read (esc)
Jump to date
Today at 4:33:51 PM
4:33
New commits deployed to Prophet Prod-EU:
[74673da](
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
) - [JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502) (steliyan-g)
GitHub
APP
Today at 5:03:19 PM
5:03 PM
3 new commits
3 new commits
pushed to
master
master
by
mihailmihaylovjiminny
mihailmihaylovjiminny
beb8e387
beb8e387
- JY-20817: Fix deleting old tracks
8f177131
8f177131
- Merge branch 'master' into JY-20817-fix-deleting-old-tracks
[CREDIT_CARD]
- Merge pull request #12052 from jiminny/JY-20817-fix-deleting-old-tracks
jiminny/app
jiminny/app
|
Added by
GitHub
GitHub
CircleCI
APP
Today at 5:29:41 PM
5:29 PM
Deployment Successful! tada emoji
Deployment Successful!
Project
: app
When
: 05/07/2026 14:29:40
Tag
:
View Job
View Job
New
CircleCI
APP
Today at 6:18:57 PM
6:18 PM
New commits deployed to Prophet Prod-US:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 6:19:24 PM
6:19
New commits deployed to Prophet Prod-EU:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Channel releases
ActivityLateMoreSlackcalVIewJiminny... vengineenins# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...:::ADOS-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv C Database ConsolesV AEUA console 1EU.DEAL RISKS EUTI#EU EUA console fiminnvGlocalho: 1891a 29m 20c4 Di giminny@localhostTrim & encode video (*E) iminny@localhc 18%#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190MistonWindowHelp* # releases9 22Messages( Files• BookmarksDeploProject:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-0 Jy 2080A Illumina•• Pull recU Useroil( JY-2071ProblenDo Search :8 JiminnyL Now Talg For youminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.J JIMINNY• Search|spaces Jiminny (NewVideo encoded successfullv.The final file size is 1,55 GB (106% ofDon t show adainVideo quality:Dimensions1812 x 1080 OriainaliEstimated file size: ~1.4 GBDon't change• Convert to moncMuteChance volumeAJ Panorama for CallScorina in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulGOWOOA100% s2•Thu 7 May 18:22:46+ CreateAsk Rovo• Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8Eoic vType vQuick filters vComplete sprintGrouo: @ueriesICODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesIND FAS...owner (user_id is.Al Reports > Emptypage design andpromotionPLATFORM STABILITYAJ REPORTSTn OAIDenloved|3 88 0000 =1 12 •000 =JY-20352•0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow ticorc to dolotaSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
Slack
|
releases (Channel) - Jiminny Inc - 3 new items - S releases (Channel) - Jiminny Inc - 3 new items - Slack...
|
NULL
|
5387
|
|
5388
|
Switch workspaces… (Jiminny Inc) Has new messages
Switch workspaces… (Jiminny Inc) Has new messages
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
1
Directories
jiminny-x-integration-app
platform-inner-team
ai-chapter
alerts
backend
bugs
confusion-clinic
curiosity_lab
engineering
general
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Stoyan Tanev
Stefka Stoyanova
Ves
Galya Dimitrova
Aneliya Angelova
Vasil Vasilev
James Graham
Nikolay Ivanov
Lukas Kovalik
you
Jira Cloud
Toast
Messages
Messages
Files
Files
Bookmarks
Bookmarks
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Today at 4:33:51 PM
4:33
New commits deployed to Prophet Prod-EU:
[74673da](
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
) - [JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502) (steliyan-g)
GitHub
APP
Today at 5:03:19 PM
5:03 PM
3 new commits
3 new commits
pushed to
master
master
by
mihailmihaylovjiminny
mihailmihaylovjiminny
beb8e387
beb8e387
- JY-20817: Fix deleting old tracks
8f177131
8f177131
- Merge branch 'master' into JY-20817-fix-deleting-old-tracks
[CREDIT_CARD]
- Merge pull request #12052 from jiminny/JY-20817-fix-deleting-old-tracks
jiminny/app
jiminny/app
|
Added by
GitHub
GitHub
CircleCI
APP
Today at 5:29:41 PM
5:29 PM
Deployment Successful! tada emoji
Deployment Successful!
Project
: app
When
: 05/07/2026 14:29:40
Tag
:
View Job
View Job
New
CircleCI
APP
Today at 6:18:57 PM
6:18 PM
New commits deployed to Prophet Prod-US:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 6:19:24 PM
6:19
New commits deployed to Prophet Prod-EU:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Channel releases
ActivityMoreSlackcalVIewJiminny... ~# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..ó- Direct messages3 Aneliya Angelova. ...8 Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...#:Apps-T lira Cloud• Toast> (h External Librariesv E Scratches and Consolesv C Database ConsolesV AEUA console 1EUDEAL RISKS EUTIninnvGlocalho: 185|A zoho dev fiiminnvGlocalh 190MistonWindowHelp@ Describe what you are looking forw releases9 22MessagesC Files& BookmarksDeplovmentTodayv!Project:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-Desk - Queues - Platform• Jy 20807 check various issues witIlluminate|Queue\MaxAttemptsExc••Pull requests • jiminny/aprU Useroilot 1 Ask liminny Report Gen• JY-20773 fix user pilot tracking ofiProblem loading page0 Search the CRM - HubSpot docs8 JiminnyLL Now TabJ JIMINNY@ For you• Recent* StarredI0+ AppsQ SpacesJiminny (New)…ull Plauorm leamII1 Caoture TeamID Enterprise Stability I..ID Processing TeamIIl SE KanbanService-Desk= More spaces= FiltersH DashboardsC÷ Operations* Confluence28 Teams"= Customise sidebarGOWOOA100% s2•Thu 7 May 18:22:48minny.aulasslan.netfa/sorware/c/oroecis/uy/ooarass,• Search|+ CreateAsk RovoSpaces / Jiminny (New)Platform Team | 9.@ Summary—TimelineE BacklogШ Active sprintsCalendar • Reports 4 Testing Board W List Forms Components %> Development% CodeMore 8• Search boardi00O008Eoic vType vQuick filters vComplete sprintGrouo: @ueriesIREADY FOR DEV 1IN DEV 5CODE REVIEWBLOCKEDQA 1|PO ACCEPTANCEDEPLOY 7Setun test coveradelfor Prophet in SonarlSmart Instant NudgePre-filteringMAINTENANCECOST-EFFECTIVE AND FAS...BacklogIn Dev3.5 0 =V JY-19951N JY-20493|AT Doviow - 01 -Summary/Actioniems/kev PointsGROWTH - MAINTAIN OURIn DovT.1Y-20566[POC)Jiminny MCPConnectonJIMINNY MCP CONNECTORIn Proaress1 •ee=• JY-20625AJ Panorama for CallScoring in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulSync opportunitiesowner (user_id is..PLATFORM STABILITYTn OAI3 88 0000 =JY-20352•Al Reports > Emptypage design andpromotionAJ REPORTSDenloved|1 12 •000 =0 JY-20372Grok via AzurelMAINTENANCEDeplovedœe=0 JY-20726Allow ticorc to dolotaSS and Panoramapromots when thos...AJ REPORTSDeployed1 8000·½ JY-20770Release AJPanorama reports tocustomersA.I REpORTSDeniovedt0.5 72 0000=O JY-20740Wrona formattina fosummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
Slack
|
releases (Channel) - Jiminny Inc - 3 new items - S releases (Channel) - Jiminny Inc - 3 new items - Slack...
|
NULL
|
5388
|
|
5389
|
Switch workspaces… (Jiminny Inc) Has new messages
Switch workspaces… (Jiminny Inc) Has new messages
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
1
Directories
jiminny-x-integration-app
platform-inner-team
ai-chapter
alerts
backend
bugs
confusion-clinic
curiosity_lab
engineering
general
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Stoyan Tanev
Stefka Stoyanova
Ves
Galya Dimitrova
Aneliya Angelova
Vasil Vasilev
James Graham
Nikolay Ivanov
Lukas Kovalik
you
Jira Cloud
Toast
Messages
Messages
Files
Files
Bookmarks
Bookmarks
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Today at 4:33:51 PM
4:33
New commits deployed to Prophet Prod-EU:
[74673da](
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
https://github.com/jiminny/prophet/commit/74673da5893290f0116af75beb652b3e4b3dce10
) - [JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502) (steliyan-g)
GitHub
APP
Today at 5:03:19 PM
5:03 PM
3 new commits
3 new commits
pushed to
master
master
by
mihailmihaylovjiminny
mihailmihaylovjiminny
beb8e387
beb8e387
- JY-20817: Fix deleting old tracks
8f177131
8f177131
- Merge branch 'master' into JY-20817-fix-deleting-old-tracks
[CREDIT_CARD]
- Merge pull request #12052 from jiminny/JY-20817-fix-deleting-old-tracks
jiminny/app
jiminny/app
|
Added by
GitHub
GitHub
CircleCI
APP
Today at 5:29:41 PM
5:29 PM
Deployment Successful! tada emoji
Deployment Successful!
Project
: app
When
: 05/07/2026 14:29:40
Tag
:
View Job
View Job
New
CircleCI
APP
Today at 6:18:57 PM
6:18 PM
New commits deployed to Prophet Prod-US:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 6:19:24 PM
6:19
New commits deployed to Prophet Prod-EU:
[3da5aed](
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
https://github.com/jiminny/prophet/commit/3da5aed8434b1d6381a35317d9ca45fd7c751e61
) - Revert "[JY-205680](
https://jiminny.atlassian.net/browse/JY-205680
https://jiminny.atlassian.net/browse/JY-205680
): Relax action items assignee (#502)" (#503) (steliyan-g)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Channel releases
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=[EMAIL]82516:22 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoin |Get a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
Slack
|
releases (Channel) - Jiminny Inc - 3 new items - S releases (Channel) - Jiminny Inc - 3 new items - Slack...
|
NULL
|
5389
|
|
5390
|
Favourites
jiminny
AirDrop
Recents
Applications
Do Favourites
jiminny
AirDrop
Recents
Applications
Documents
Downloads
lukas
iCloud
iCloud Drive
Sync folder
Locations
DXP4800PLUS-B5F
Eject
Network
Tags
CRM
Orange
Red
Yellow
Green
Blue...
|
Finder
|
Recents
|
NULL
|
5390
|
|
5391
|
Firefox FileEditView•<→ G= [1 Google MeetHistor Firefox FileEditView•<→ G= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com1822556:22 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoin |33m 20s1,55 GBTrim & encode video (*E)Finder$1PSlwolLộ3...
|
Finder
|
Recents
|
NULL
|
5391
|
|
5392
|
Favourites
jiminny
AirDrop
Recents
Applications
Do Favourites
jiminny
AirDrop
Recents
Applications
Documents
Downloads
lukas
iCloud
iCloud Drive
Sync folder
Locations
DXP4800PLUS-B5F
Eject
Network
Tags
CRM
Orange
Red
Yellow
Green
Blue
Purple
All Tags…
Name
Kind
Date Last Opened
arch.pdf
PDF Document
14 December 2021 at 14:26
laravel.png
PNG image
17 February 2022 at 19:04
sf_square.png
PNG image
23 February 2022 at 16:54
ppedrive.png
PNG image
23 February 2022 at 16:56
bh.png
PNG image
23 February 2022 at 16:59
bh_square.png
PNG image
23 February 2022 at 17:01
crm.png
PNG image
23 February 2022 at 17:04
crm_square.png
PNG image
23 February 2022 at 17:05
base64.sh
Terminal scripts
24 July 2022 at 14:38
transliterateCyr.sh
Terminal scripts
24 July 2022 at 15:01
transliterateLat.sh
Terminal scripts
24 July 2022 at 15:02
Untitled.scpt
Script
9 August 2022 at 19:48
CleanShot 2022-08-25 at [EMAIL]
PNG image
25 August 2022 at 18:24
background-ineverted.jpg
JPEG image
11 January 2023 at 16:25
background-large-inverted.jpg
JPEG image
11 January 2023 at 16:28
background-large.jpg
JPEG image
11 January 2023 at 16:28
background.jpg
JPEG image
11 January 2023 at 16:29
index.html
HTML document
18 January 2023 at 10:16
audio.wav
Waveform audio
10 May 2023 at 8:43
hubspot.png
PNG image
20 July 2023 at 19:18
copper.png
PNG image
4 August 2023 at 18:15
SidekickService.php.html
HTML document
4 August 2023 at 21:50
sidekick_white.svg
SVG document...
|
Finder
|
Recents
|
NULL
|
5392
|
|
5393
|
Favourites
jiminny
AirDrop
Recents
Applications
Do Favourites
jiminny
AirDrop
Recents
Applications
Documents
Downloads
lukas
iCloud
iCloud Drive
Sync folder
Locations
DXP4800PLUS-B5F
Eject
Network
Tags
CRM
Orange
Red
Yellow
Green
Blue
Purple
All Tags…
Name
Date Modified
Size
Kind
Name
Date Modified
Size
Kind
Connecting…
Connect As…
0 items
DXP4800PLUS-B5F...
|
Finder
|
DXP4800PLUS-B5F
|
NULL
|
5393
|
|
5394
|
Favourites
jiminny
AirDrop
Recents
Applications
Do Favourites
jiminny
AirDrop
Recents
Applications
Documents
Downloads
lukas
iCloud
iCloud Drive
Sync folder
Locations
DXP4800PLUS-B5F
Eject
Network
Tags
CRM
Orange
Red
Yellow
Green
Blue
Purple
All Tags…
Name
Date Modified
Size
Kind
Name
Date Modified
Size
Kind
Connecting…
Connect As…
0 items
DXP4800PLUS-B5F...
|
Finder
|
DXP4800PLUS-B5F
|
NULL
|
5394
|
|
5395
|
Favourites
jiminny
Firefox FileEditView€ <→ C= Favourites
jiminny
Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com183:006:23 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
Finder
|
Work
|
NULL
|
5395
|
|
5396
|
ActivityMorerindelJiminny... v# engineering# gener ActivityMorerindelJiminny... v# engineering# general# jiminny-bg# platform-tickets# product launches# random# releases# sofia-office# support# thank-yous# the_people_of jimi...• Direct messages3 Aneliya Angelova, ...2. Stoyan Tanev •a. Stefka StoyanovaP. Ves%. Galya Dimitrova8. Aneliya Angelova€. Vasil Vasilevdo James GrahamC. Nikolay IvanovE. Lukas Kovalik y...:::ADOSJira Cloud® Toast> ib External Librariesv E® Scratches and Consoles~ D Database ConsolesV AEUA console 1EUDEAL RISKS EUTIninnv@localho: 185F1 33m 20s165 GPalocalhostTrim & encode video (*E)SF [iminny@localhost]A zoho dev fiiminnvGlocalh 190Windowmelp&3 # releases8 22Messages© Files& BookmarksDeploymentToday~Project:When:app05/07/2026 14:29:40lag.View JobCircleCI APP 6:18 PMNew commits deployed to Prophet Prod-(3da5aed][URL_WITH_CREDENTIALS] Token refresh and retry successful','team_id' => $client->getConfig()->getTeam()->getId(),Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\Exceptions$ Service-Desk - Queues - Platform• Jy 20807 check various issues witlluminate|Queue|MaxAttemptsExc/••Pull requests • jiminny/aprU Useroilot 1 Ask liminny Report Gen( JY-20773 fix user pilot tracking ofProblem loading pageSo Search the CRM - HubSpot docs8 Jiminny+ New Tab& JIMINNY@ For you(• Recent# Starred0+ AppsQ SpacesJiminny (New)ll Plauorm leamII Capture TeamaID Enterprise StaW Processing Te:II1 SE KanbanService-Desk= More spaces= FiltersH DashboardsC÷ Operations2 Confluence:8 Teamsºa Customise sidebalminny.aulasslan.net/lfa/sorware/cloroecis/uy/ooaras/s.Q SearchSpaces / Jiminny (New)Platform Team ®® Summary—TimelineE BacklogID Active sprints© CalendarI Reports4 Testing BoardQ Search board |00O008Epic vType vQuick filters vREADY FOR DEV 1IN DEV 5Setun test coveradefor Prophet in SonarMAINTENANCESmart Instant NudgePre-filteringDXP4800PLUS-B5Fconnected as: Adminjiminny(® AirDrop• RecentsA Applications( Documents• Downloadslukasi Youtubet WYOrKt Testim screenpipetm personal_folder* MusicMoviod• iCloud Drivet MartiGooale228 Svnc foldem Family tree documentsO DXP4800PLUS-B5F al Documentsdocker•.IV-20625AJ Panorama for CallScoring in ODAUTOMATED AI SCORINGIIn Dev2.5 =[ JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYIn DevCODE REVIEWBLOCKEDViewGroup Share Edit TagsActionDate ModifiedsnarepointSharepointSharepointSharepointsnarepolntSharenoint20 items-o hil o100% 12Thu 7 May 18:23:00+ CreateAsk RovoHistE Formse Components⅘› Development% CodeMore 8Complete sprintGroup: QueriesQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesowner user_ld ls.PLATFORM STABILITYIn QA3 l) 0000=/JY-20352Al Reports > Emptypage design andpromotionAJ REPORTSDeployed1 12 •000 =0 JY-20372Grok via AzurelMAINTENANCEDeploved|œe=[ JY-20726Allow ticorc to dolotaSS and Panoramapromots when thos...AJ REPORTSDeployed1| Y) •000=·½ JY-20770Release AJPanorama revorts tocustomersA.I REpORTSDeployed0.5 X1 0000 =JY-20740Wrona formattina forsummary in the CRMMAINTENANCEDeployed3Ý•00=...
|
Finder
|
Work
|
NULL
|
5396
|
|
5397
|
ActivityMorerindelJiminny... vd engineenns# genera ActivityMorerindelJiminny... vd engineenns# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...:::ADOS-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EUDEAL RISKS EUTIninnv@localho: 185F1 33m 20s165 GPalocalhostTrim & encode video (XE)Z SF(iminny@localhost]A zoho dev fiiminnvGlocalh 190Windowmelp* # releases9 22MessagesC Files& BookmarksDeplovmentTodayv!Project:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] - Plattorm XSevenShores\Hubspot\ExceptionsService-Desk - Queues - Platform• Jy 20807 check various issues witIlluminate|Queue\MaxAttemptsExc• Pull requests • jiminny/appU Useroilot 1 Ask liminny Report Gen( JY-20773 fix user pilot tracking ofProblem loading page0 Search the CRM - HubSpot docs8 JiminnyLL Now TabsetPagination(PaginationState $state, int Sresulteded(Client Sclient, PaginationState $state): voiest(Client Sclient, string Sendpoint, array $paylstanceO->getClientO->request( method: 'POST'. Seleadersonbotl DEBUG Getting headers'. [P? C.medExcentionSe))<Sthis->Loggen->warning(' Hubsoot Got 401 durina pagination. attemotinol'team id' => ScLient-›aetconfiao->qetTeamo-›getido.'error' => Se->aetMessageolSclient->ensureValidTokenO-Sstate->undatel.astTokenCheckotry{Snesnonse = Sclient->aetInstance@->aetClient@->request/method:p$this->logger->info('[Hubspot) Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.J JIMINNY@ For you• Recent* StarredI0+ AppsQ SpacesJiminny (New)ll Plauorm leamI1l Caoture TeamI1 Enternrise St.ID Processing TeII1 SE KanbanService-Desk= More spaces= FiltersH DashboardsC÷ Operations* Confluence:8 TeamsY= Customise sidebaminny.aulasslan.netlfa/sorware/c/loroecis/cy/ooarass.• Search|Spaces / Jiminny (New)Platform Team | 9.( Summary—TimelineE Backlog• Search boardiREADY FOR DEV 1IN DEV 5Setuo test coveragefor Prophet in SonarlSmart Instant NudgePre-filteringMAINTENANCEworkjiminny(® AirDropDailv 2026-05-07 mn.@ Recents4 Applications( Documents(•) DownloadsA lukas• iCloud Drive228 Svnc foldeanatione1-12026-04-24.mp4= Daily 2026-04-21 mn4User Pilot introduction Adi 2026-04-23.mp4Daily 2026-04-23.mp4Daily 2026-04-22.mo4ER Refinement 2026-04-06.mp4= Daily 2026-04-21.mp4D Refinement 2026-04-20.mn4Daily 2026-04-20 mn4Dailv 2026-04-17 mp4iu Daily 2026-04-16.mp4- Plannina 2026-04-15.mo4Retro 2026-04-14.mp4Daily 2026-04-14 mn/@ DXP4800PLUS-B5F•.IV-20625AJ Panorama for CallScoring in ODAUTOMATED AI SCORINGIIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulIl Active sorints1Calendan~ Renorts4Testing Board |Eoic vType vQuick filters vCODE REVIEWBLOCKEDO00 VGroupShare Edit TagsDoto ModifiodActionToday at 10:12Today at 10:1024 Apr 2026 at 14:4424 Anr 2026 at 10:1123 Apr 2026 at 11:5823 Apr 2026 at 10:3222 Aor 2026 at 10:2121 Apr 2026 at 11:0221 Apr 2026 at 10:0020 Aor 2026 at 16.0020 Anr 2026 at 10:0617 Apr 2026 at 10:1616 Apr 2026 at 10:0015 Aor 2026 at 11:1414 Apr 2026 at 17:3714 Anr 2026 at 10:00Search931,7 MB1,86 GB822 2 MB MP724 MB M:1,74 GB1.36 GB|2,41 GB MP567,8 MB4.26 GB608 5 MR MI1,16 GB513,4 MB2.75 GB1,44 GB ME0214MR MO150 items. 1.97 TR availableS0 hl100% 12Thu 7 May 18:23:03+ CreateAsk RovoHeist≥Formsn Comnonents⅘ Develonment% CodeMore 8Grouo: QueriesQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesowner user_ld ls.PLATFORM STABILITYIn OAITФ000=/JY-20352Al Reports > Emptypage design andpromotionAJ REPORTSDenloved|1 12 •000 =0 JY-20372Grok via AzurelMAINTENANCEDeploved|œe=0 JY-20726Allow ticorc to dolotoSS and Panoramapromots when thos...AJ REPORTSDeployed1| Y) •000=·½ JY-20770Release A.lPanorama revorts tocustomersA.I REpORTSNenioved0.5 X1 0000 =I.JY-20740Wrona formattina forsummary in the CRMMAINTENANCENeniovodl3Ý•00=...
|
iTerm2
|
NULL
|
NULL
|
5397
|
|
5398
|
Firefox FileEditView€ <→ C= [1 Google MeetHisto Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com183036:23 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
iTerm2
|
NULL
|
NULL
|
5398
|
|
5399
|
ActivityMorerindelJiminny... vd engineenns# genera ActivityMorerindelJiminny... vd engineenns# general# jiminny-bg# platform-tickets# product launches# random# releases# soha-ofhce# support# thank-vous# the people of jimi..o- Direct messages3 Aneliya Angelova. ...Stovan Tanev €Stefka StoyanovaFal Ves% Galya Dimitrova DAneliva Angelova6 Vasil Vasilev&o James Grahamed Nikolay IvanovLukas Kovalik y...:::ADOS-T lira Cloud• Toast> ih External Librariesv E Scratches and Consolesv O Database ConsolesV AEUA console 1EUDEAL RISKS EUTIninnv@localho: 185F1 33m 20s165 GPalocalhostTrim & encode video (XE)Z SF(iminny@localhost]A zoho dev fiiminnvGlocalh 190Windowmelp* # releases9 22MessagesC Files& BookmarksDeplovmentTodayv!Project:appWhen.05/07/2026 14:29:40lag.View JobCircleCl APP 6:18 PMNew commits deployed to Prophet P[URL_WITH_CREDENTIALS] Token refresh and retry successful'.l'team id' => $client->getConfiq(->qetTeam©->qetIdo.Plattorm Sprint s @2 - Plattorm XSevenShores\Hubspot\ExceptionsService-Desk - Queues - Platform• Jy 20807 check various issues witIlluminate|Queue\MaxAttemptsExc••Pull requests • jiminny/aprU Useroilot 1 Ask liminny Report Gen( JY-20773 fix user pilot tracking ofProblem loading page0 Search the CRM - HubSpot docs8 JiminnyLL Now TabJ JIMINNY@ For you• Recent* StarredI0+ AppsQ SpacesJiminny (New)ll Plauorm leamI1l Caoture TeamI1 Enternrise St.IN Processing TeII1 SE KanbanService-Desk= More spaces= FiltersH DashboardsC÷ Operations* Confluence:8 TeamsY= Customise sidebaminny.aulasslan.net/lfa/sorware/cloroecis/uy/ooaras/s.• Search|Spaces / Jiminny (New)Platform Team | 9.( Summary—TimelineE Backlog• Search boardiREADY FOR DEV 1IN DEV 5Setun test coveradelfor Prophet in SonarlSmart Instant NudgePre-filteringMAINTENANCEworkjiminnyOpen in New Tab(® AirDrop@ RecentsMove to Rin4 Applications( DocumentsGet into•) DownloadsComoress "2026'A lukasDuolicateMake AliasQuick Look• iCloud Drive228 Svnc foldecopyanatione0cddc00@ DXP4800PLUS-B5FQuick ActionsServicesAJ Panorama for CallScoring in ODAUTOMATED AI SCORINGIn Dev2.5=JY-20361[HubSpot] OptimiseCRM rematchina ondelete hubsoot..PLATFORM STABILITYTn NoulШ Active sprints1Calendan~ Renorts4Testing Board |Eoic vType vQuick filters vCODE REVIEWBLOCKED23.mp4O00 VGroupShare Edit TagsDoto ModifiodActionToday at 10:12Today at 10:1024 Apr 2026 at 14:4424 Anr 2026 at 10:1123 Apr 2026 at 11:5823 Apr 2026 at 10:3222 Aor 2026 at 10:2121 Apr 2026 at 11:0221 Apr 2026 at 10:0020 Aor 2026 at 16.0020 Anr 2026 at 10:0617 Apr 2026 at 10:1616 Apr 2026 at 10:0015 Aor 2026 at 11:1414 Apr 2026 at 17:3714 Apr 2026 at 10:09Search1,86 GB822 2 MB MP724 MB M:1,74 GB1.36 GB|2,41 GB MP567,8 MB4.26 GB608 5 MR MI1,16 GB513,4 MB2.75 GB1,44 GB ME0214MR MO50 items, 1,97 TB available>0 lel100% 12Thu 7 May 18:23:04+ CreateAsk RovoHeist¿Formsn Comnonents⅘ Develonment% CodeMore 8Comolete soriniGrouo: QueriesQA 1|PO ACCEPTANCEDEPLOY 7Sync opportunitiesowner user_ld ls.PLATFORM STABILITYIn OAITФ000=/JY-20352Al Reports > Emptypage design andpromotionAJ REPORTSDenloved|1 12 •000 =0 JY-20372Grok via AzurelMAINTENANCEDeploved|œe=0 JY-20726Allow ticorc to dolotoSS and Panoramapromots when thos...AJ REPORTSDeployed1| Y) •000=·½ JY-20770Release A.lPanorama revorts tocustomersA.I REpORTSNenioved0.5 X1 0000 =I.JY-20740Wrona formattina forsummary in the CRMMAINTENANCENeniovodl3Ý•00=...
|
iTerm2
|
NULL
|
NULL
|
5399
|
|
5400
|
Firefox FileEditView€ <→ C= [1 Google MeetHisto Firefox FileEditView€ <→ C= [1 Google MeetHistoryBookmarksProfilesToolsWindow Help= meet.google.com/landing?authuser=lukas.kovalik@jiminny.com183:046:23 PM • Thu, May 7+Meetings0 CallsSecure video conferencingfor everyoneConnect, collaborate, and celebrate from anywhere withGoogle MeetEk New meetingEnter a code or nicknameJoinGet a link you can shareClick New meeting to get a link you can send to peopleyou want to meet with...
|
iTerm2
|
NULL
|
NULL
|
5400
|
|
5401
|
Favourites
jiminny
AirDrop
Recents
Applications
Do Favourites
jiminny
AirDrop
Recents
Applications
Documents
Downloads
lukas
iCloud
iCloud Drive
Sync folder
Locations
DXP4800PLUS-B5F
Eject
Network
Tags
CRM
Orange
Red
Yellow
Green
Blue
Purple
All Tags…
Name
Date Modified
Size
Kind
2026
Today at 10:12
--
Folder
CleanShot 2026-05-07 at 17.30.37.mp4
Today at 18:21
1,55 GB
MPEG-4 movie
Daily 2026-05-07.mp4
Today at 10:10
931,7 MB
MPEG-4 movie
1-1 2026-04-24.mp4
24 Apr 2026 at 14:44
1,86 GB
MPEG-4 movie
Daily 2026-04-24.mp4
24 Apr 2026 at 10:11
832,2 MB
MPEG-4 movie...
|
Finder
|
Work
|
NULL
|
5401
|
|
5402
|
Copying “CleanShot 2026-05-07 at 17.30.37.mp4” to Copying “CleanShot 2026-05-07 at 17.30.37.mp4” to “2026”
stop progress
134,2 MB of 1,55 GB - Estimating time remaining…...
|
Finder
|
Copy
|
NULL
|
5402
|
|
5403
|
Copying “CleanShot 2026-05-07 at 17.30.37.mp4” to Copying “CleanShot 2026-05-07 at 17.30.37.mp4” to “2026”
stop progress
134,2 MB of 1,55 GB - Estimating time remaining…...
|
Finder
|
Copy
|
NULL
|
5403
|
|
5404
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5404
|
|
5405
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
PhostormVIewINavigareCodeLaravelKeractorProiect vT DeleteCrmEntity lratt.onp=.env.qa=.env.qai=.env.root=.env.staging=.gitattributes.gitignore.php-cs-fixer.cache© RateLimitException.php© HubspotPaginationService.php X ©PaginationState.php© Hubs!T OpportunitySyncTrait.ph©) Hubspotsinglesyncstrategy.php© HubspotWebhookBatchSyncStrategy.phgmoortopportunity8atch.onoImportBatchJobTrait.php(c) Hubspot/Service.php(C) PayloadBuilder.pho© MatchActivityCrmData.phppnp.onp-cs-rixer.aist.onp(C) CrmActivityService.ohcCachedCrmServiceDecorator.php•Hubspot/....SyncCrmEntitiesTrait.php(C) Pipedrive/Service.phppnp.pnostorm.meta.pnpE.phpunit.result.cacheE.prettierignore1Servicelnterface.ohdcllass HuhsnotPaoinationServilceA19 V1 л=.winasunrulesprp _lde_nelper.pnpphpldeneloermodels.onophp artisancomposer.isoncomposer.lockdenendencv-checker.isondev.ison= ids.txt=infection.ison.distMIINSTALL.mdMIINTERNAL WEBHOOK SETUP m 142=jiminny_storageMJlicenses.mdMMakofile© package-lock.jsonE phpstan.neon.distE phpstan-baseline.neon<> phpunit.xmlTa raw_saL.query.salMIDSANMAS md167169< sonar-project.propertiesE test.py<)> Untitled Diagram.xmlJs vetur.confia.isM+ WEBHOOK FILTERING_IMPLEM 175> ih External Librariesv E° Scratches and Consolesv O Database Consoles178V AEUA console 1EUA DEAL RISKS (EU1180ninnv@localho: 185F1 33m 20sTrim & encode video (XE)#SE fliminnvAlocalhost]A zoho dev fiiminnvGlocalh 190private function handlePaginationStrategyCreturn Soavload:lusageprivate function shouldSwitchToKeysetPagination(PaginationStqte $state, int SresultsPerPage): boolf-.no usagesprivate function validateTokenIfNeeded(Client Sclient, PaginationState $state): voidi...}private function executeSearchRequest(Client Sclient, string $endpoint, array $payload, PaginationStatrySresponse = Sclient->qetInstance(->qetClient(->request( method: "POST', Sendpoint, ['ison' =Sheaders = Sresponse->qetHeadersO:Sthis->logger->info('[Hubspot] DEBUG Getting headers'. ['headers' => Sheaders ?? [.return Sresponse->toArrav@:} catch (\Exception $e) {if Sclient->isUnauthorizedExceot.ionSe))<Sthis->Logger->warning('[Hubspot) Got 401 during pagination, attempting token refresh',*t'team id' => ScLient-›aetconfia0->getTeamo->qetido.'error' => Se->aetMessageolSclient->ensureValidTokendSstate->undatel.astTokenCheckotry{Snesnonse = Sclient->aetInstance@->aetclien+@->nequest/method: pnst: Sendnoint$this->logger->info('[Hubspot) Token refresh and retry successful', [team id' => $client->getConfiq(->qetTeamO->qetIdo=custom.logElaravel.logA SF (jiminny@localhost]4 HS_local (iminny@localhost] >iti accounts (jiminny@localhost]A console (PROD]# console [eu)A console [STAGING]Tx: Autov liminnySELECT * FRUM crm_tieLd_data WhERE crm_layout_entity_1d IN (6494,6495,64%6,6497,0498,0499); m 06 A1 x6 ~37 VSELECTGEEEc0 coco coCONCAT(u.id, CASE WHEN .id = t.owner_id THEN ' (owner)' ELSE "' END) AS user_id,u.emarsa.*t.owner 1d FROM social accounts saJOIN users Uon U.id = sa.sociable 1dJOIN teams t l..n<->1: on t.id = u.team_idWHERE U.team_id = 2 and sa.provider = 'hubspot';select * from social accounts whene id = 1409•select * from opportunities where team_id = 2and crm_provider_id IN ('51317301383');select * from contacts where id = 85;select * from opportunities where team id = 2 order by id desc:select * from opportunities where team id = 2 and crm provider id = '51317301383': # 5112select * from opportunities where team id = 2 and crm provider id = '55976759904': # 5112select * from opportunity contacts where opportunity id = 5117:select * trom crm tleld data where obnect 10 = 15057SELECT * FROM crm_fields WHERE id IN (1405, 1407. 1972, 2128):select * tromselect * from team features where team id IN (1):select * from team features where feature id IN (36):SHOW CREATE TABLE opportunity_contacts;SELEC * FROM opportunity contactsWHERE crm provider 1d = 111751'4"Ssiud & "HURSPOT WERHOOK SYNCIS# Steam = Jiminnv Models Team: • find(2)•# $feature = Feature::query(->where('slug', $slug)->firstO:# TeanFeature::quenv()->create(['feature id' => Sfeature->aetId() Iteam id! => Steam->aetId@l)•# hubsnot wehhook metricslselect * from opportunities where team_id = 2 and crm_provider_id IN ('374720564', '14527423589' , •49908861993', '504SELECT * FROM opportunity contacts WHERE opportunity id = '414';SELECT * FROM opportunity contacts WHERE crm_provider id = '131501';colort + fnom contante whono id in (414LAA•select * from activities where crm confiquration id = 2:select settings from crm confiqurations where id = 11;100% 52Thu 7 May 18:23:37AskJiminnyReportActivityServiceTest -CascadeHubspot Rate LimitingHubSpot Search Rate168a Fast Context Find all HubSpot search APl calls includina crm/vs/obiects//search endpoints and request methods ... In 3.28SBased on my analvsis, here are all HubSpot search APl calls in the codebase:Summary of All HubSpot Search API Calls1. Pacination Service (HubsootPaqinat ionService.oho line 36)• php$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";Used by opportunity sync strategies to paginate through deals/companies/contacts2. Service.php - Multiple search endpointsMethodEndpointPurpose/crm/v3/obiects/companies.contacts)/searchName search for contacts/companieshandLePhoneSearchRequestol/crm/v3/obiects/contacts/searchPhone number matchingcrm/v3/obrects/calls/searchImport calls bv periodsearchcaulsForPeriodByPage)/crm/v3/objects/calls/searchPaginated call search/crm/v3/objects/calls/searchFind call by recording URL3. PayloadBuilder.php generates payloads for•generatedoportunitySearchPavioad - Deal search tor sunc stratediesgenerateSearchContactsByNamePayload() - Contact name searchgeneratePhoneSearchPav oad - Phone searchgenerateSearchCallsByPeriodPayload() - Call period searchgeneratecetcallsPavloado - Call import searchaenerateSearchCal1BvTokenPavload/ - Calll bv token searchlKey Findings1. No RetrvzAfter header in cearch recnonses - Your dehua lod confirms this. HubSnot doecn't send rate limit quidance in search2 Pate limits are enforced cerver-cide.ten cecondlv rollina • 10 reauects ner 10 ceconde•secondly → 1 request per second (for search endpoints)3. Current retry loaic (in Service, oho lines 1723-1727)AohrSretrvAfter = isset (Sresponse ('policvName'))fc. Cresnonsel"nolicvNane'l == celf.-TEN CECONDIY pOLITNG pOLTCY? self::TEN_SECONDLY ROLLING LIMITII10 seconds•1. I Default 1 cecondRecommendationSince soarch ADic don!t return Petru-After headers the current annroach of ucing nolicvlane from the error recnonce body ic thelets move all search request to header undel...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5405
|
|
5406
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5406
|
|
5407
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5407
|
|
5408
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5408
|
|
5409
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5409
|
|
5410
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5410
|
|
5411
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5411
|
|
5412
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5412
|
|
5413
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5413
|
|
5414
|
Project: faVsco.js, menu
master, menu
Start Listen Project: faVsco.js, menu
master, menu
Start Listening for PHP Debug Connections
AskJiminnyReportActivityServiceTest
Run 'AskJiminnyReportActivityServiceTest'
Debug 'AskJiminnyReportActivityServiceTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
6
1
6
Previous Highlighted Error
Next Highlighted Error
# [PASSWORD_DOTS] HS [PASSWORD_DOTS]
select * from teams where id = 2; # 2
select * from features; # 2
select * from team_features where team_id = 2; # 2
select * from crm_configurations where id = 2; # 2
select * from users where team_id = 2; #
select * from playbooks where team_id = 2; # event 38
select * from playbook_categories where playbook_id = 38; #
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id is not null order by id desc;
[URL_WITH_CREDENTIALS] HubspotException
* @throws SocialAccountTokenInvalidException
* @throws BadRequest
*/
public function getPaginatedDataGenerator(
Client $client,
array $payload,
string $type,
int $offset = 0,
int &$total = 0,
?string &$lastRecordId = null
): \Generator {
$state = new PaginationState(offset: $offset);
$endpoint = Client::BASE_URL . "/crm/v3/objects/{$type}/search";
$defaultFilter = $payload['filters'] ?? [];
$resultsPerPage = PayloadBuilder::MAX_SEARCH_REQUEST_LIMIT;
$teamId = $client->getConfig()->getTeam()->getId();
$delay = $this->calculateDelayInMicroseconds();
do {
// if ($this->shouldStopPagination($state, $teamId)) {
// break;
// }
$payload = $this->handlePaginationStrategy($payload, $defaultFilter, $state, $resultsPerPage, $teamId);
// $this->validateTokenIfNeeded($client, $state);
// usleep($delay);
$page = $this->executeSearchRequest($client, $endpoint, $payload, $state);
// $state->setTotal($page['total'] ?? 0);
// $this->updateLastRecordId($page, $state);
//
// // Safely iterate over results with null check
// $results = $page['results'] ?? [];
// foreach ($results as $row) {
// $state->incrementTotalRecords();
// yield $row;
// }
//
// $state->setOffset($this->getNextOffset($page));
// $state->incrementRequestCount();
//
// $this->logPaginationProgress($state, $teamId, $endpoint);
} while ($state->offset && ! empty($page['results']));
// Log final pagination completion stats
$this->logger->info('[Hubspot] Pagination completed', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'total_requests' => $state->requestCount,
'total_records_fetched' => $state->totalRecords,
'total_elapsed_seconds' => round($state->getElapsedSeconds(), 2),
'average_seconds_per_request' => $state->requestCount > 0 ? round($state->getElapsedSeconds() / $state->requestCount, 2) : 0,
]);
// Update reference parameters
$total = $state->total;
$lastRecordId = $state->lastRecordId;
yield;
}
private function shouldStopPagination(PaginationState $state, int $teamId): bool
{
if ($state->hasReachedSafetyLimit()) {
$this->logger->warning('[Hubspot] Reached maximum request limit during pagination', [
'team_id' => $teamId,
'safety_limit' => PaginationConfig::LOOP_SAFETY_LIMIT,
'total_fetched' => $state->totalRecords,
]);
return true;
}
return false;
}
private function handlePaginationStrategy(
array $payload,
array $defaultFilter,
PaginationState $state,
int $resultsPerPage,
int $teamId
): array {
if ($this->shouldSwitchToKeysetPagination($state, $resultsPerPage)) {
$payload['filters'] = $defaultFilter;
$payload['filters'][] = [
'propertyName' => 'hs_object_id',
'operator' => 'LT',
'value' => $state->lastRecordId,
];
$this->logger->info('[Hubspot] Search keyset pagination request', [
'team_id' => $teamId,
'sequence' => $state->requestCount,
'itemsPerPage' => $resultsPerPage,
'payload' => $payload,
'total' => $state->total,
]);
unset($payload['after']);
$state->setOffset(0);
}
if ($state->offset) {
$payload['after'] = $state->offset;
}
return $payload;
}
private function shouldSwitchToKeysetPagination(PaginationState $state, int $resultsPerPage): bool
{
// Check if we've hit the offset limit
$shouldSwitch = $state->requestCount > 0 && ($state->offset + $resultsPerPage) > PaginationConfig::TOTAL_QUERY_LIMIT;
if ($shouldSwitch && $state->lastRecordId === null) {
$this->logger->warning('[Hubspot] Cannot switch to keyset pagination: lastRecordId is null', [
'request_count' => $state->requestCount,
'current_offset' => $state->offset,
'results_per_page' => $resultsPerPage,
'total_query_limit' => PaginationConfig::TOTAL_QUERY_LIMIT,
]);
return false; // Continue with offset pagination
}
return $shouldSwitch;
}
private function validateTokenIfNeeded(Client $client, PaginationState $state): void
{
if ($state->shouldValidateToken()) {
$client->ensureValidToken();
$state->updateLastTokenCheck();
}
}
private function executeSearchRequest(Client $client, string $endpoint, array $payload, PaginationState $state): array
{
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$headers = $response->getHeaders();
$this->logger->info('[Hubspot] DEBUG Getting headers', [
'headers' => $headers ?? [],
]);
return $response->toArray();
} catch (\Exception $e) {
if ($client->isUnauthorizedException($e)) {
$this->logger->warning('[Hubspot] Got 401 during pagination, attempting token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'error' => $e->getMessage(),
]);
$client->ensureValidToken();
$state->updateLastTokenCheck();
try {
$response = $client->getInstance()->getClient()->request('POST', $endpoint, ['json' => $payload]);
$this->logger->info('[Hubspot] Token refresh and retry successful', [
'team_id' => $client->getConfig()->getTeam()->getId(),
]);
return $response->toArray();
} catch (\Exception $retryException) {
$this->logger->error('[Hubspot] Retry request failed after token refresh', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'original_error' => $e->getMessage(),
'retry_error' => $retryException->getMessage(),
]);
throw $retryException;
}
} else if ($client->isHubspotRateLimit($e)) {
$retryAfter = $client->parseRetryAfter($e);
$this->logger->info('[Hubspot] Received 429 from API', [
'team_id' => $client->getConfig()->getTeam()->getId(),
'config_id' => $client->getConfig()->getId(),
'retry_after' => $retryAfter,
'reason' => $e->getMessage(),
]);
throw new RateLimitException('Hubspot returned 429', $retryAfter, $e);
} else {
throw $e;
}
}
}
private function updateLastRecordId(array $page, PaginationState $state): void
{
$lastRecord = ! empty($page['results']) ? end($page['results']) : null;
$lastRecordId = $lastRecord['id'] ?? null;
$state->updateLastRecordId($lastRecordId);
}
private function getNextOffset(array $page): int
{
return isset($page['paging']['next']['after']) ? (int) $page['paging']['next']['after'] : 0;
}
private function logPaginationProgress(PaginationState $state, int $teamId, string $endpoint): void
{
if ($state->shouldLogProgress()) {
$this->logger->info('[Hubspot] Pagination progress log', [
'team_id' => $teamId,
'endpoint' => $endpoint,
'requests_made' => $state->requestCount,
'records_fetched' => $state->totalRecords,
'elapsed_seconds' => $state->getElapsedSeconds(),
]);
}
}
private function calculateDelayInMicroseconds(): int
{
return (int) (1 / PaginationConfig::SEARCH_RPS_LIMIT * 1000000);
}
}
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – HubspotPaginationService.php
|
NULL
|
5414
|