Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]);