Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

script editor - Hanging on reload

We are trying to pull data from Service Now using the Rest Connector
Pull data for base table and sub-tables and Create a QVD
It hangs mid way
This was working fine till 3 weeks ago

REST Connector  - Hanging on reload


QV_issue.jpg




JOIN

join

[assigned_to]:

LOAD [display_value_u7] as assigned_to,

[link_u7] as assigned_to_link,

[__FK_assigned_to] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_assigned_to]);

join

[assignment_group]:

LOAD [display_value_u4] as assignment_group,

[link_u4] as assignment_group_link,

[__FK_assignment_group] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_assignment_group]);

join

[caller_id]:

LOAD [display_value_u3] as caller_id,

[link_u3] as caller_id_link,

[__FK_caller_id] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_caller_id]);

join

[closed_by]:

LOAD [display_value_u5] as closed_by,

[link_u5] as closed_by_link,

[__FK_closed_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_closed_by]);

join

[cmdb_ci]:

LOAD [display_value_u2] as cmdb_ci,

[link_u2] as cmdb_ci_link,

[__FK_cmdb_ci] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_cmdb_ci]);

join

[company]:

LOAD [display_value_u6] as company,

[link_u6] as company_link,

[__FK_company] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_company]);

join

[location]:

LOAD [display_value_u8] as location,

[link_u8] as location_link,

[__FK_location] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_location]);

join

[opened_by]:

LOAD [display_value_u0] as opened_by,

[link_u0] as opened_by_link,

[__FK_opened_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_opened_by]);

join

[resolved_by]:

LOAD [display_value] as resolved_by,

[link] as resolved_by_link,

[__FK_resolved_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_resolved_by]);

join

[rfc]:

LOAD [display_value_u9] as rfc,

[link_u9] as rfc_link,

[__FK_rfc] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_rfc]);

join

[sys_domain]:

LOAD [display_value_u1] as sys_domain,

[link_u1] as sys_domain_link,

[__FK_sys_domain] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_sys_domain]);

0 Replies