GET api/store/{id}/replication/peek?limit={limit}

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id

integer

Required

limit

integer

Default value is 1000

Body Parameters

None.

Response Information

Resource Description

Collection of ReplicationCommand
NameDescriptionTypeAdditional 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": "84e2caf4-36f4-4250-9475-4f99ca8d3392",
    "sql": "sample string 2",
    "sqlHash": "sample string 3",
    "transaction": {
      "$id": "2",
      "id": "2c3ff0e8-b953-4456-9dba-a620f7f52c06",
      "dataSource": "d96c353e-7e0e-483b-867e-97e911dc500a",
      "sourceIDs": [
        1,
        2
      ]
    },
    "parameters": {
      "$id": "3"
    },
    "replicationParameters": {
      "$id": "4",
      "sample string 1": {
        "$id": "5"
      },
      "sample string 2": {
        "$id": "6"
      }
    },
    "emptyParameters": true,
    "targets": [
      "95feffa4-b764-4b27-baec-157e8c91af15",
      "dedc114d-b5bd-49ba-8253-320bf601a4c5"
    ],
    "created": "2025-10-05T00:03:56.8141436",
    "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>2025-10-05T00:03:56.8141436+00:00</Created>
    <CreatedTimestamp>7</CreatedTimestamp>
    <EmptyParameters>true</EmptyParameters>
    <ID>84e2caf4-36f4-4250-9475-4f99ca8d3392</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>95feffa4-b764-4b27-baec-157e8c91af15</d3p1:guid>
      <d3p1:guid>dedc114d-b5bd-49ba-8253-320bf601a4c5</d3p1:guid>
    </Targets>
    <Transaction>
      <DataSource>d96c353e-7e0e-483b-867e-97e911dc500a</DataSource>
      <ID>2c3ff0e8-b953-4456-9dba-a620f7f52c06</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>2025-10-05T00:03:56.8141436+00:00</Created>
    <CreatedTimestamp>7</CreatedTimestamp>
    <EmptyParameters>true</EmptyParameters>
    <ID>84e2caf4-36f4-4250-9475-4f99ca8d3392</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>95feffa4-b764-4b27-baec-157e8c91af15</d3p1:guid>
      <d3p1:guid>dedc114d-b5bd-49ba-8253-320bf601a4c5</d3p1:guid>
    </Targets>
    <Transaction>
      <DataSource>d96c353e-7e0e-483b-867e-97e911dc500a</DataSource>
      <ID>2c3ff0e8-b953-4456-9dba-a620f7f52c06</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|E[�g	�5xl/workbook.xml �(�����0��&�C���J")��x��-�4П�5���H�yۙ��v�l�ȍ�GM�W��C�"ċ�'cA�]o�b!J�"�鹿ֈ�H�e%q0� ������X�:`���V�bR��x@�.͞f�d4�����"�)�`�ERH35nY`%���8��U2෎�W^�B\�s�w��d��|PK|E[����	�[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
|E[,�i''_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="Rf191e45ab2f14530" /></Relationships>PK|E[�zcWDxl/worksheets/sheet1.xml �(���Ks�0F��G��z?2@&m�&Yu�h�.��l1�����X�@��G��:\���f��i�j���!�t�4��}���_��v1���*�}����9�����[V�)]n��
{kc�҇K�R���^�{��5����VoJZ���:p���Znku��n��K5e݂�lU�ꇻϬ^���y& +��]�;[g���5��p�ر�~����J�����2�G]�T>Hb]fi6�{͚��dM�޽�땯怈KN�RT)�0Ȗ;�M�縍>����S�\0H!��K)��I�'���}���L�3�8G�3L.�Y�g���D� s,.�y��C�\)�$��qN/�E�C^���TJJC~����rȓ\��q���W}^
y�KE�@�!Ɗ]�#�1@p� s���JI��8b7���/3k���C���.,]7�a|]�Ҽ-�x;d{��@c�۔�c�~J�1�}J�1�0%ؘ�1%��x�bL<M	9&���:E|���x�0֜@b�	$�@b�	$V�@b�	$��@b�H�y3EX!*�c��H'�pr]x��'�Xx��'�Xx��'�Xx����'�gϔ*��j�`�׶{��,�PK|E[���Pxl/_rels/workbook.xml.rels �(���Kn�0@�b;��!D`æ[�{�D$vdZ��E��+ԢRk�.�a5��ӓf>�?6��y"�n4��4a@P#Gݷp�ꩆ�vs���0�qq$�h������ԉg���e��}HmO.N�G�1VR3�I���C4J��F�g��0}5��D��m��������&�
�Y�p���]��T���K �aj�_'t�^�y$S�d��VS��2�(_�
����r�Vc#s̤�U�����_l�PK|E[Ѓc'2E
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|E[�HJ^5xl/sharedStrings.xml �(��RQO�0�+˞݆c �m<��D#�xv�V�v����[�2�&�4���׻���ɻ�j�J�s��:�X�sU$�cv�\��D�0q�H�3Ic"�X���-��/��X�ȯjT�YWZ��O]Tk��JD#E�z�@W�êF��&i�48=6Oc������q�{}!ˍ��*�p�A0c{kS��A������g�u]��l��t���Z�p�%Z�e��G�֑��#
=o]�h=3���8lk��#ЎN�I:����>���E�� ?C�q$�ȟ��/^/�dP�w/��L9������9*Ԝ�3�@o���w�r_��?
<L��tM�(k��|u$�ާ�PK-|E[�g	�5xl/workbook.xmlPK-|E[����	�[Content_Types].xmlPK-
|E[,�i''V_rels/.relsPK-|E[�zcWD�xl/worksheets/sheet1.xmlPK-|E[���Pkxl/_rels/workbook.xml.relsPK-|E[Ѓc'2E
�xl/styles.xmlPK-|E[�HJ^5+	xl/sharedStrings.xmlPK��

application/vnd.ms-excel

Sample:
PK|E[tA���5xl/workbook.xml �(�����0D�&�C��P*N\�z��"
�%m
~��o�vfg�N>k3�Z�#Ge3S�޹)c�6=J�'=��N	�K�b��D��n��c<�Rfp'����,]i���dZ�#:9�(	B��x $_�=�6Holu��5�~Sy��AZ�J�soSb2�G��oך'��/��;{��l�]~PK|E[����	�[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
|E[|�ĭ''_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="R289e18781cbe46eb" /></Relationships>PK|E[�zcWDxl/worksheets/sheet1.xml �(���Ks�0F��G��z?2@&m�&Yu�h�.��l1�����X�@��G��:\���f��i�j���!�t�4��}���_��v1���*�}����9�����[V�)]n��
{kc�҇K�R���^�{��5����VoJZ���:p���Znku��n��K5e݂�lU�ꇻϬ^���y& +��]�;[g���5��p�ر�~����J�����2�G]�T>Hb]fi6�{͚��dM�޽�땯怈KN�RT)�0Ȗ;�M�縍>����S�\0H!��K)��I�'���}���L�3�8G�3L.�Y�g���D� s,.�y��C�\)�$��qN/�E�C^���TJJC~����rȓ\��q���W}^
y�KE�@�!Ɗ]�#�1@p� s���JI��8b7���/3k���C���.,]7�a|]�Ҽ-�x;d{��@c�۔�c�~J�1�}J�1�0%ؘ�1%��x�bL<M	9&���:E|���x�0֜@b�	$�@b�	$V�@b�	$��@b�H�y3EX!*�c��H'�pr]x��'�Xx��'�Xx��'�Xx����'�gϔ*��j�`�׶{��,�PK|E[�f|��Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞8qB⠦ݰa[z��Q;�]�gc���V� �X��j4��'�|�lvo�D^Ї���,�V:5ڡ�S�wv��'�D0�HZ����@i�g2��M��,bJ�@!�b@��~̀k&9���i=J|t�4������`#����~J�^B�%*�'��^������e�0��L-�����;_�ȾT�@������2FxT�ѧK����Z���l�{^ ��/j��/�_PK|E[Ѓc'2E
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|E[�HJ^5xl/sharedStrings.xml �(��RQO�0�+˞݆c �m<��D#�xv�V�v����[�2�&�4���׻���ɻ�j�J�s��:�X�sU$�cv�\��D�0q�H�3Ic"�X���-��/��X�ȯjT�YWZ��O]Tk��JD#E�z�@W�êF��&i�48=6Oc������q�{}!ˍ��*�p�A0c{kS��A������g�u]��l��t���Z�p�%Z�e��G�֑��#
=o]�h=3���8lk��#ЎN�I:����>���E�� ?C�q$�ȟ��/^/�dP�w/��L9������9*Ԝ�3�@o���w�r_��?
<L��tM�(k��|u$�ާ�PK-|E[tA���5xl/workbook.xmlPK-|E[����	�[Content_Types].xmlPK-
|E[|�ĭ''V_rels/.relsPK-|E[�zcWD�xl/worksheets/sheet1.xmlPK-|E[�f|��Pkxl/_rels/workbook.xml.relsPK-|E[Ѓc'2E
�xl/styles.xmlPK-|E[�HJ^5*	xl/sharedStrings.xmlPK��