GET api/store/{id}/replication/peek?limit={limit}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
Required |
|
| limit | integer |
Default value is 1000 |
Body Parameters
None.
Response Information
Resource Description
Collection of ReplicationCommand| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
Unique identifier for the command |
globally unique identifier |
None. |
| Sql |
SQL command text |
string |
None. |
| SqlHash |
SQL command hash |
string |
None. |
| Transaction |
When set, this groups the ReplicationCommand as part of a batch |
ReplicationTransaction |
None. |
| Parameters |
SQL parameters - dict, POCO or anonymous type |
Object |
None. |
| ReplicationParameters |
SQL Parameters - serialisable |
Dictionary of string [key] and ReplicationParameter [value] |
None. |
| EmptyParameters | boolean |
None. |
|
| Targets |
List of Targets |
Collection of globally unique identifier |
None. |
| Created |
Date the command was created |
date |
None. |
| CreatedTimestamp | integer |
None. |
Response Formats
application/json, text/json
Sample:
[
{
"$id": "1",
"id": "a21a24f1-7e7e-4c40-839a-a82b0d9a1861",
"sql": "sample string 2",
"sqlHash": "sample string 3",
"transaction": {
"$id": "2",
"id": "907d02c0-c7cb-4b7f-bec9-0f1206c91d24",
"dataSource": "5cd73430-f3c7-439b-95d1-71423642db07",
"sourceIDs": [
1,
2
]
},
"parameters": {
"$id": "3"
},
"replicationParameters": {
"$id": "4",
"sample string 1": {
"$id": "5"
},
"sample string 2": {
"$id": "6"
}
},
"emptyParameters": true,
"targets": [
"f5abfcef-5f53-447f-b3a7-b405e7298a9f",
"d05bd425-514e-47a2-8f4f-9811514dc754"
],
"created": "2026-04-03T06:26:07.2007438",
"createdTimestamp": 7
},
{
"$ref": "1"
}
]
application/xml, text/xml
Sample:
<ArrayOfReplicationCommand xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.Tenancies.Replication">
<ReplicationCommand>
<Created>2026-04-03T06:26:07.2007438+00:00</Created>
<CreatedTimestamp>7</CreatedTimestamp>
<EmptyParameters>true</EmptyParameters>
<ID>a21a24f1-7e7e-4c40-839a-a82b0d9a1861</ID>
<Parameters />
<ReplicationParameters xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:Key>sample string 1</d3p1:Key>
<d3p1:Value />
</d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:Key>sample string 2</d3p1:Key>
<d3p1:Value />
</d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
</ReplicationParameters>
<Sql>sample string 2</Sql>
<SqlHash>sample string 3</SqlHash>
<Targets xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:guid>f5abfcef-5f53-447f-b3a7-b405e7298a9f</d3p1:guid>
<d3p1:guid>d05bd425-514e-47a2-8f4f-9811514dc754</d3p1:guid>
</Targets>
<Transaction>
<DataSource>5cd73430-f3c7-439b-95d1-71423642db07</DataSource>
<ID>907d02c0-c7cb-4b7f-bec9-0f1206c91d24</ID>
<SourceIDs xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d4p1:int>1</d4p1:int>
<d4p1:int>2</d4p1:int>
</SourceIDs>
</Transaction>
</ReplicationCommand>
<ReplicationCommand>
<Created>2026-04-03T06:26:07.2007438+00:00</Created>
<CreatedTimestamp>7</CreatedTimestamp>
<EmptyParameters>true</EmptyParameters>
<ID>a21a24f1-7e7e-4c40-839a-a82b0d9a1861</ID>
<Parameters />
<ReplicationParameters xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:Key>sample string 1</d3p1:Key>
<d3p1:Value />
</d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
<d3p1:Key>sample string 2</d3p1:Key>
<d3p1:Value />
</d3p1:KeyValueOfstringReplicationParameterOT8kAyz1>
</ReplicationParameters>
<Sql>sample string 2</Sql>
<SqlHash>sample string 3</SqlHash>
<Targets xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:guid>f5abfcef-5f53-447f-b3a7-b405e7298a9f</d3p1:guid>
<d3p1:guid>d05bd425-514e-47a2-8f4f-9811514dc754</d3p1:guid>
</Targets>
<Transaction>
<DataSource>5cd73430-f3c7-439b-95d1-71423642db07</DataSource>
<ID>907d02c0-c7cb-4b7f-bec9-0f1206c91d24</ID>
<SourceIDs xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d4p1:int>1</d4p1:int>
<d4p1:int>2</d4p1:int>
</SourceIDs>
</Transaction>
</ReplicationCommand>
</ArrayOfReplicationCommand>
text/csv
Sample:
Sample not available.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK C3�\��=� 5 xl/workbook.xml � (� ����0��&�C��h")��x��Э4П�5���H�yۙ��v�l��3�����\��lE��P̟�w�8�B��E�����o:�K���Ă4��z���ay�q? 5�(Ť���]�=%�>�hlu�5D~S4�����f
jܲ�0JΝ�����d%�]Q����ٵ�nxg�0J���PK C3�\���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
C3�\�:�9' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R3a23e43e4d184c48" /></Relationships>PK C3�\��ZDY D xl/worksheets/sheet1.xml � (� ��Ks�0F�
þ���c;��u��:]�kjˁ�AI���+01Fh�L����|W�p����}t�Ha�D5����Ezt�/"�[�Oڼ�R)�x��3�HK��<��RՅ��A5~n�M]8h�s��U�қc��# XnԾp~)[V���}��=Ul�S���RuQ5�r��|����v��Ξp���y����^��v'�~i��tl>����?M�U��w���AUϥ�h������jեI]�u��j��E�E9��@! �~bs�N�����9��<��!�8@"����>��3O�<��� �T2����>O��bH�$�!~;��<�eR)��1r;��<�<�['B⫰�}^y�q,�Q����>/�<��O�` !Io�!xo 0T�D9� �� ?7b��˹ѧ�tӾ~;��C���o_�o��%��m�'�N 8&�M 4&VS���S������c�ǔ`c�aJ�1�8%Ęx��B�^��2,���Ps =G�Pt MG�Pu ]G�Pv m�#�������?2�~��p<�� ��
� ��
� ��
� �p�y������R�ׯ2k��2�S��`�PK C3�\X\b� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8 �4�i7ݰ-���'Q;��B�Ƃ#q�"A*�`��h~OO��|�Xoߦ�������$FFZ5���S�+�n�{1� ��gq����'ν�iB�ؙL�h�&1u�Q�#��i�ݒ�Lv�����z����4� ���uG�`t�~J�_C�D*�g�¾VJTU]�L�Z4����|������=jTs�2,����L���Kp��K�ey�&dS�sB̋R�W5~��/PK C3�\Ѓc'2 E
xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK C3�\��] 5 xl/sharedStrings.xml � (� �RMO�@�+M��hJ9����z"&ہ��ݖ����z4�����{�vf�L2����@M�Tc7�C�A�ʜ���}����(���u&iBd+U4vc�� V���
�e6��`l��U!��H�a8$p�:����em�Z�]��#`K�41��, L���Y���=Pц3
��;[�z
���<c%8���;�VV��3�[4g���`0�3.�Z-�6qqyC��g������Q��k�F���!��@�:m7���x_|
���E�� ?C�q$���
������ ��xP�?G��3� ��-^��-_����^�ϤƎ��5�W'���}�
PK- C3�\��=� 5 xl/workbook.xmlPK- C3�\���� � [Content_Types].xmlPK-
C3�\�:�9' ' V _rels/.relsPK- C3�\��ZDY D � xl/worksheets/sheet1.xmlPK- C3�\X\b� P m xl/_rels/workbook.xml.relsPK- C3�\Ѓc'2 E
� xl/styles.xmlPK- C3�\��] 5 , xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
Sample:
PK C3�\ $��� 5 xl/workbook.xml � (� ����0��&�C�� �N\�zm�-ik���'�x�3;���u��ږ|tg|�J*C�s�<���l�f� �4�Q��B(���o�&�c������K�{���a��!4^"�-(
��j�#���=~���֝L�M3l��1���5�dvnMIcJ\���FYv�� �䒦��{�l�]}PK C3�\���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
C3�\�ʱW' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Raad6b0b8076a48ed" /></Relationships>PK C3�\��ZDY D xl/worksheets/sheet1.xml � (� ��Ks�0F�
þ���c;��u��:]�kjˁ�AI���+01Fh�L����|W�p����}t�Ha�D5����Ezt�/"�[�Oڼ�R)�x��3�HK��<��RՅ��A5~n�M]8h�s��U�қc��# XnԾp~)[V���}��=Ul�S���RuQ5�r��|����v��Ξp���y����^��v'�~i��tl>����?M�U��w���AUϥ�h������jեI]�u��j��E�E9��@! �~bs�N�����9��<��!�8@"����>��3O�<��� �T2����>O��bH�$�!~;��<�eR)��1r;��<�<�['B⫰�}^y�q,�Q����>/�<��O�` !Io�!xo 0T�D9� �� ?7b��˹ѧ�tӾ~;��C���o_�o��%��m�'�N 8&�M 4&VS���S������c�ǔ`c�aJ�1�8%Ęx��B�^��2,���Ps =G�Pt MG�Pu ]G�Pv m�#�������?2�~��p<�� ��
� ��
� ��
� �p�y������R�ׯ2k��2�S��`�PK C3�\��{� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8���TM�aö��3��&vd�@�Ƃ#q�"A*�`��h~OO��|���ަ�����-�,FV�n�}���j�m7{1��`�9��bC&�y�yP�&��ɦ�v~R���{�E���_2����CtZ��:Md�`���1�쀾���O)�KY�{�Zؗy�T��
�}YJ
��L-��H���;_��TZ�BV�Ժ���AO�S���K�ey�&�ϵ�0_�R ����~PK C3�\Ѓc'2 E
xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK C3�\��] 5 xl/sharedStrings.xml � (� �RMO�@�+M��hJ9����z"&ہ��ݖ����z4�����{�vf�L2����@M�Tc7�C�A�ʜ���}����(���u&iBd+U4vc�� V���
�e6��`l��U!��H�a8$p�:����em�Z�]��#`K�41��, L���Y���=Pц3
��;[�z
���<c%8���;�VV��3�[4g���`0�3.�Z-�6qqyC��g������Q��k�F���!��@�:m7���x_|
���E�� ?C�q$���
������ ��xP�?G��3� ��-^��-_����^�ϤƎ��5�W'���}�
PK- C3�\ $��� 5 xl/workbook.xmlPK- C3�\���� � [Content_Types].xmlPK-
C3�\�ʱW' ' W _rels/.relsPK- C3�\��ZDY D � xl/worksheets/sheet1.xmlPK- C3�\��{� P n xl/_rels/workbook.xml.relsPK- C3�\Ѓc'2 E
� xl/styles.xmlPK- C3�\��] 5 - xl/sharedStrings.xmlPK � �